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

["Vaidyanathan, Ramakrishnan \(GE, Corporate,consultant\)" <ramakrishnan.vaidyanathan@ge.com>]

Hi

  Iam getting error when i use the following shell script

sqr /t111/app01/psoft/usdx/usr/sqr/parallel.sqr -RT uid/pwd@ORACLE_SID  
-i/t111/app01/psoft/usdx/sqr/ -ZIF/t111/app01/psoft/usdx/sqr/pssqr.unx 1

Iam calling sqr called parallel.sqr thru shell program. last parameter in the 
above syntax is "1" that i want to pass to the sqr.
pls help

Thanks
Ram

-----Original Message-----
From: sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org
[mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org]On
Behalf Of Heather Philp
Sent: Thursday, April 05, 2007 8:26 AM
To: 'This list is for discussion about the SQR database
reportinglanguagefrom Hyperion Solutions.'
Subject: RE: [sqr-users] passing parameters to sqr..


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

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