How to insert variable date (monthly) from SQL script Post: 302544440

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

script variable within a sql query

I created a script to read a csv file with four columns. The script also saved values of each col in a arry. In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file. select Num from tableName where Sec_Num in ('${isin}') /*isin is an arry...

2. Shell Programming and Scripting

Convertion of Date Format using SQL query in a shell script

When I write Select date_field from TableA fetch first row only I am getting the output as 09/25/2009. I want to get the output in the below format 2009-09-25 i.e., MM-DD-YYYY. Please help

3. Shell Programming and Scripting

Pass a variable to SQL script

Hi Guys, I like to pass a variable to a sql file in a unix script.. I tried a below code.. var=200903 db2 -vf test.sql 200903 test.sql is as below. select * from db2.users where quarter = $1; Please tell me where i go wrong.. Thanks in advance, Magesh

4. Shell Programming and Scripting

script to insert variable file into another, bit like C's #include

Hi, I want to insert one file into another like this: file 1: 1 2 3  4 5  6 with the complete output going to another file. Have seen some solutions to similar problems using sed, but this problem is different because it is...

5. Programming

How to put variable date from SQL Script

Hi Guys, Can someone please help me on adding/inserting a variable to an sql scipt? Basically I want to assign today's date. As shown below.. set head off; set linesize 300; set pagesize 200; spool /opt/oracle/temp/output.txt select value,count(*) as totalcount from pmowner.pinpebasev...

6. Shell Programming and Scripting

How to put date range from a perl & sql script

Hi Guys, Can someone please help me on adding/inserting a variable date to an sql scipt? Basically I want to assign a 7 days date range. As shown below.. #!/usr/bin/perl use strict; use Env qw(ORACLE_HOME); my $SQLPLUS='/opt/oracle/product/10.1.0/db_1/bin/sqlplus -S...

7. UNIX for Dummies Questions & Answers

SQL Script to use variable value from input file

Here is the requirement, When I run the "run file KSH (sql)", it should substitute '${pCW_Bgn_DT}' with 201120 and '${pCW_End_DT}' with 201124 Input File ---------- $ cat prevwk.dat 201124 20110711 run file KSH (sql) ------------------ In this file, I want to use the variables...

8. Shell Programming and Scripting

Passing variable from file to sql from script

Hi Friend, I have one file in which some number are mentioned and number of lines are vary every time And i need to pass that number to my sql command from script. Suppose i have file acc.txt 45456546456 45464564565 67854353454 67657612132 Number of records are vary every time....

9. UNIX for Beginners Questions & Answers

BASH SCRIPT - Insert date into cells in cvs file

Hi, I'm looking to accomplish the following. Insert current date into three places/cells within a cvs, every time the bash script is executed. The cells are column A,B,C row 2. Row 1 is reserved for the headers. The file name is always orders.csv. These three cells we always have an old...

10. Shell Programming and Scripting

Csv files sort by date and zip monthly

Hi, I'm an absolute beginner in shell programming. I would need a script for a NAS that makes the csv files sorted by date and always monthly a zip. In the current month, the data should be integrated into this folder, so there are only monthly files. Thanks for your help

LEARN ABOUT DEBIAN

osd_clock

OSDClock(1)						      General Commands Manual						       OSDClock(1)

NAME

       osd_clock - X on-screen clock displayer

SYNOPSIS

       osd_clock [OPTION]... [+FORMAT]

DESCRIPTION

       Display date/time information on screen.

       -f FONT
	      Set font.

       -c COLOR
	      Set color.

       -d DELAY
	      Sets the delay (in seconds) that the clock is exposed.  Useful if combined with INTERVAL.

       -F FORMAT
	      This option specifies the format to be used to output the date.  See 'strftime(3)'.

       -i INTERVAL
	      This specifies the interval between displays.  Default is 1 (display every second).

       -H INTEGER
	      The "chimes per hour" count overrides -i. Default is 0 (no effect).

	      The  time will be displayed this many times each hour (notwithstanding signals interrupting sleep, and leap seconds). The first dis-
	      play of the hour will be on the hour exactly. Use -H 4 for a display at 0, 15, 30 and 45 minutes past.

       -s SHADOW
	      This option sets the shadow depth.  Default 2.

       -t     locate clock at top left (default: bottom left).

       -b     locate clock at bottom left (default).

       -o OFFSET
	      This option specifies the offset from the top or bottom of screen the text is displayed. The default is 0.  Useful to move above	or
	      below panels or applets.

       -h, --help
	      display this help and exit

BUGS

       The per-hour mode may fire up to one second late, or worse if the system is busy.

AUTHOR

       Jon Beckham <leftorium@leftorium.net>
       Martijn van de Streek <martijn@foodfight.org>
       Nathan Walp <faceprint@faceprint.com>

COPYRIGHT

       It is distributed under the GNU General Public License.

X OSD Clock							    March 2001							       OSDClock(1)