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

["Dwight Schrute" <schrute.dwight@hotmail.com>]

You are passing the parameters in the wrong sequence.  You have a flag (-RT) 
then your database connection and then more flags.  Pass all the flags and 
then the connection.  Like this:

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


>From: "Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)" 
><ramakrishnan.vaidyanathan@ge.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] passing parameters to sqr..
>Date: Fri, 13 Apr 2007 11:28:12 -0400
>
>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

_________________________________________________________________
Exercise your brain! Try Flexicon. 
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglineapril07


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