Passing parameters with a SQLTALK BAT INPUT ........ COMMAND

comp.databases.gupta (1995-2015)
Jamie

Passing parameters with a SQLTALK BAT INPUT ........ COMMAND

Post by Jamie » 17 Mar 2003, 11:51

 Posted by:  dont...@yahoo.com (Jamie) 

Hi all,

I have a the following .rpt file i use as my input. i want to be abel
to pass the date parameter when i run it from a command line:

CONNECT SERVER;
SET PAGESIZE 50000;
set DEVICESIZE 5000;
SET LINESIZE 4999;
SELECT * from database where date = '02-MAR-2003';
disCONNECT SERVER;

How would i go about passing the date?
I am running the following from the command line:

SQLTALK BAT INPUT=JAMIE.RPT OUTPUT=OUTPUT.TXT

Thanks

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 0 guests