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

[Donald Mellen <donm@ontko.com>]

Actually, it should be connection, then flags. Like this:

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

The above assumes you have a ".sqt" file created and in place.  Since 
you are specifying -RT to use the sqt file, it would be more efficient 
to use sqrt and the sqt file name, like:

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

HTH,
Don

Dwight Schrute wrote:
> 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
>


-- 
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@ontko.com |  "In the beginning, there was nothing, which exploded"


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