RE: [sqr-users] passing parameters to sqr..

["Heather Philp" <Heather.Philp@dal.ca>]

Yes, we run all our sqr programs at the unix level and pass parameters to
them.
 
Sample of the sqr code...
   INPUT $jobname
   INPUT $one_up
   INPUT $v_output_dir
   INPUT $v_database


Sample of the Unix shell script 
sqr ${prog}.sqr -RT ${uid}/${pswd}@$ORACLE_SID ${PROG} ${one_up}
${output_dir} ${dbase} 

Data is accepted as character, so if you have dates/number you need to
convert

Note, we run using precompiled sqt's.  Using this method, the ask command
will not work, only the input.

Heather 
 
-----Original Message-----
From: Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
[mailto:ramakrishnan.vaidyanathan@ge.com] 
Sent: April 4, 2007 2:11 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] passing parameters to sqr..

Hi,
 
    Is it possible to pass parameters to the sqr while calling that sqr thru
Unix shell script?Please help me with some code snippets how to go about it.

Thanks
Ram




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users