How to pass date to SQL server SP? Post: 302923964

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pass multiple variables to SQL script

I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time. ## Accept variable(s) from the command line...

2. Shell Programming and Scripting

Pass variable to sql

Please help. I got these error. I'm try to pass variable extract from data-file.txt to sql file(select.sql). cat: cannot open select cat: cannot open * cat: cannot open from cat: cannot open user cat: cannot open where cat: cannot open name=$list; #!/bin/bash list=`sed q...

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

Pass the first date and last date of previous month

Hi All, I need to run a job every month at the beginning of the month which is scheduled through autosys, lets say on 03/01/2010. I need to pass the last month's i.e February's first_date = 02/01/2010 and last_date = 02/28/2010 as variables to a stored procedure. Can somebody please pass...

5. Shell Programming and Scripting

How to pass value from unix shell to sql session?

Here is the situation, I have file from which I am reading records line by line. Based upon some condition I need to pass a field from a sql session to get some data from a table. I don't have any idea how to do it....

6. Shell Programming and Scripting

Pass perl array to SQL oracle

Hello, Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg : #!/usr/bin/perl @v_array = (1,2,4,5,6,8); $db_userid = 'ni71/ni711'; $bufTPO = qx{ sqlplus -s << EOF $db_userid set verify off set feedback off set...

7. Programming

pass value from Oracle sql to Korn shell

Hi All , I am trying to pass a value from sqlplus to korn shell . There is a table tab1 in Oracle that has a column userdate. I need to pass the userdate to the korn shell . This is what I am doing . VALUE=`sqlplus -silent username/password << END set pagesize 0 feedback off verify off...

8. Shell Programming and Scripting

How to pass string into sql query?

Hi Gurus, I have a request which needs to pass string into sql. dummy code as below: sqlplus -s user/password@instance << EOF >>output.txt set echo off head off feed off pagesize 0 trimspool on linesize 1000 colsep , select emp_no, emp_name from emp where emp_no in ('a', 'b', 'c'); exit;...

9. Shell Programming and Scripting

How to pass a shellscript variable to a sql file?

Hi, i wan't to pass a shellscript variable to a sql file. a.sql select $field from dual; the way i am calling this is through sqlplus field_name="sysdate" sqlplus -s username/password@hostname:port/servicename <<EOF @a.sql $field_name EOF

10. UNIX for Advanced & Expert Users

To pass one month range in sql script

Hi Guys, i am having .sql script which inserts data from one table to another table based on date condition, i need to pass range on based on how many number of months, for e.g set timing on; whenever sqlerror exit failure; spool myscript.log append accept start_date...

LEARN ABOUT LINUX

dh_installman

DH_INSTALLMAN(1)						     Debhelper							  DH_INSTALLMAN(1)

NAME

       dh_installman - install man pages into package build directories

SYNOPSIS

       dh_installman [debhelperoptions] [manpage...]

DESCRIPTION

       dh_installman is a debhelper program that handles installing man pages into the correct locations in package build directories. You tell it
       what man pages go in your packages, and it figures out where to install them based on the section field in their .TH line. If you have a
       properly formatted .TH line, your man page will be installed into the right directory, with the right name (this includes proper handling
       of pages with a subsection, like 3perl, which are placed in man3, and given an extension of .3perl). If your .TH line is incorrect or
       missing, the program may guess wrong based on the file extension.

       It also supports translated man pages, by looking for extensions like .ll.8 and .ll_LL.8, or by use of the --language switch.

       If dh_installman seems to install a man page into the wrong section or with the wrong extension, this is because the man page has the wrong
       section listed in its .TH line. Edit the man page and correct the section, and dh_installman will follow suit. See man(7) for details about
       the .TH section. If dh_installman seems to install a man page into a directory like /usr/share/man/pl/man1/, that is because your program
       has a name like foo.pl, and dh_installman assumes that means it is translated into Polish. Use --language=C to avoid this.

       After the man page installation step, dh_installman will check to see if any of the man pages in the temporary directories of any of the
       packages it is acting on contain .so links. If so, it changes them to symlinks.

       Also, dh_installman will use man to guess the character encoding of each manual page and convert it to UTF-8. If the guesswork fails for
       some reason, you can override it using an encoding declaration. See manconv(1) for details.

FILES

       debian/package.manpages
	   Lists man pages to be installed.

OPTIONS

       -A, --all
	   Install all files specified by command line parameters in ALL packages acted on.

       --language=ll
	   Use this to specify that the man pages being acted on are written in the specified language.

       manpage ...
	   Install these man pages into the first package acted on. (Or in all packages if -A is specified).

NOTES

       An older version of this program, dh_installmanpages(1), is still used by some packages, and so is still included in debhelper.	It is,
       however, deprecated, due to its counterintuitive and inconsistent interface. Use this program instead.

SEE ALSO

       debhelper(7)

       This program is a part of debhelper.

AUTHOR

       Joey Hess <joeyh@debian.org>

8.9.0ubuntu2.1							    2012-06-12							  DH_INSTALLMAN(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pass multiple variables to SQL script

Discussion started by: jagannatha

2. Shell Programming and Scripting

Pass variable to sql

Discussion started by: killboy

3. Shell Programming and Scripting

Pass a variable to SQL script

Discussion started by: mac4rfree

4. Shell Programming and Scripting

Pass the first date and last date of previous month

Discussion started by: vigdmab