Re: Running Sqr and using sqr parameters in process definition

[Arthur Coniglio <Arthur.CONIGLIO@EDDEPT.WA.EDU.AU>]

Dominick,

We use the Input Command which we have placed within the Init-Report section

eg.  we have one sqr which accepts 5 variables from the process defintion
        input $HDR_UNION
        input $HDR_DEPTID
        input $HDR_TERM
        input $HDR_YEAR
        input $ABSENCE_TYPE

the process definition setup is as follows:
        append      :vac_book_wa.union_cd :vac_book_wa.deptid
:vac_book_wa.break_term_wa :vac_book_wa.year_relate_wa
                    :vac_book_wa.absence_type


Couple things to note:
        - our SQR is defined as an Sqr Process rather than Sqr Report due to
the fact we use PeopleCode to
        fire of the sqr.
        - the length of the append text is limited to the length of the dos
command which eludes me at this moment,
        something like 251 chars....


Hope this helps.

Regards
Arthur C.



-----Original Message-----
From: Dominick LoGiudice [mailto:dlogiudice@PINE.VPCC.SUNYSB.EDU]
Sent: Wednesday, October 06, 1999 11:40 PM
To: Multiple recipients of list SQR-USERS
Subject: Running Sqr and using sqr parameters in process definition


I can run an a sqr in the process sceduler no problems.  When I set up the
process
defintion I
see a sqr parameter option there. The documentation says you can set up a
param for
any field in
your current panel  group.
I have a record in the panel group called pay_cntrl  and a field called
asofdate.
So in the sqr parameter i did this
append   :pay_cntrl..asofdate

How do I use this in my sqr ?