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

bookman

bookman(1)																bookman(1)

NAME

       bookman - Generate a book from man pages

SYNOPSIS

       bookman [-pPxn] [-o outfile] [-a author] [-d date] [-r release]
       [-t title] [-v volume] [-c coverfile] [manfile]

DESCRIPTION

       bookman	compiles  a  set  of  man  pages files specified by manfile arguments, or if no manfile is given, filenames are read from standard
       input.

OPTIONS

       -p     PDF output format.

       -P     Postscript output format.

       -x     X11 previewing, using gxditview(1).

       -n     no format, output is direct gtroff intermediate format.

       -o outfile
	      Output in file outfile. Default is standard output.

       -a author
	      Set the author, on the cover page.

       -d date
	      Set the date on the cover page.

       -r release
	      Set the book name and release on the cover page.

       -t title
	      Set the title on the cover page.

       -v volume
	      Specify the name of the volume.

       -c coverfile
	      Uses the file coverfile to generate the cover page, i.e. all pages preceding the table of content. coverfile must be in  groff_ms(7)
	      format.

EXAMPLE

       To build a reference manual from section 2 man, do:

	   $ cd /usr/man/man2
	   $ bookman -p -t 'Unix Reference Manual' * >book.pdf

SEE ALSO

       man(1), mandoc(7), groff_ms(7), groff(1), troff(1), grops(1), gxditview(1), ps2pdf(1).

AUTHOR

       Marc Vertes <mvertes@free.fr>

txt2man-1.5.5							   11 April 2011							bookman(1)