Re: reading SQR parameters / command line flags

["Banks, Richard" <Richard.Banks@CBA.COM.AU>]

Jamie's answer (poor deluded Queenslander that he is!) was applicable for
v7.5, in v8+ the table in question is currently called PSPRCSPARMS however
the problem is that they are stored in some form of meta data, ie

PSPRCSPARMS.PARMLIST for a sample process is;

-CT DB2UNIX -CS  -CD F82BBLD2 -CA %ACCESSID% -CAP %ACCESSPSWD% -RP H5GL2563
-I 16819 -R H5GL2563_REPORT -CO HATEMF -OT 2 -OP "c:\temp\" -OF 2

where I think -OP = output path, -OF = output format (2=PDF, 3=CSV) etc
would require a bit of debugging, however if that's what it takes..

I think PS binaries interpret this meta data into process type specific
parameters, pretty clever really, just frustrating when you can't access
that logic!  So that would indeed be a backup plan which I may end up using.
I will be using the process scheduler for the reports (I just develop using
command line), however would prefer a solution that doesn't rely on it.

> -----Original Message-----
> From: Michael Lee [SMTP:homestoremike@YAHOO.COM]
> Sent: Tuesday, June 04, 2002 3:44 PM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: reading SQR parameters / command line flags
>
> 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