Re: reading SQR parameters / command line flags

[Jamie Allen <jamesa@CYB.COM.AU>]

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.
**************************************************