Re: reading SQR parameters / command line flags

[Michael Lee <homestoremike@YAHOO.COM>]

This is only true if you are running the SQR using
Process Scheduler.  Richard's example below shows that
he is running it through command line/Windows client,
which will not write to PSPRCSRQST.

Mike

--- Jamie Allen <jamesa@CYB.COM.AU> wrote:
> Have a look at the table PSPRCSRQST and try the
> following:
>
> SELECT PARMLIST
> FROM PSPRCSRQST
> WHERE PRCSINSTANCE = '?????'
>
> This should get what your after.
>
> Go Queenslander!!!!
>
> -----Original Message-----
> From: Banks, Richard
> [mailto:Richard.Banks@CBA.COM.AU]
> Sent: Tuesday, 4 June 2002 09:23
> To: SQR-USERS@list.iex.net
> Subject: reading SQR parameters / command line flags
>
>
> Inside SQR can I find out what parameters were used
> to process that SQR?
>
> e.g. if I execute my SQR using
> c:\sqr\sqrw.exe c:\sqr\h5gl2565.sqr  F82BINT2/*/*
> -Ic:\sqr\ -KEEP -Fc:\temp\
> -Oc:\temp\sqr.log -PRINTER:EP -debugABCD
>
> is there some undocumented string (like
> $SQR-PARAMETERS) that I could then
> search through to find if a certain flag had been
> set - specifically I would
> love to know if the user has requested CSV (-EH_CSV)
> format and alter my
> print statements accordingly to not worry about
> printing headers.
>
> I imagine as a fallback I could hunt through the
> PeopleSoft tables as it
> must be stored somewhere, but I really don't want to
> (it involves derived
> records and got complex quickly!) - anyone know the
> table in question that
> stores PARMLIST?
>
>
> **************   IMPORTANT MESSAGE  **************
> This e-mail message is intended only for the
> addressee(s) and contains
> information which may be confidential. If you are
> not the intended recipient
> please advise the sender by return email, do not use
> or disclose the
> contents, and delete the message and any attachments
> from your system.
> Unless specifically indicated, this email does not
> constitute formal advice
> or commitment by the sender or the Commonwealth Bank
> of Australia (ABN 48
> 123 123 124) or its subsidiaries.
> **************************************************


__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com