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

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

And the error message would be? 

-----Original Message-----
From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
[mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On Behalf 
Of Vaidyanathan, Ramakrishnan (GE,
Corporate,consultant)
Sent: Saturday, 14 April 2007 1:28 AM
To: This list is for discussion about the SQR database reportinglanguage 
fromHyperion Solutions.
Subject: RE: [sqr-users] passing parameters to sqr..

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



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