Re: Thanks a lot- passing parameters- help

[Kathy Anderson <AndersoK@ROTARYINTL.ORG>]

When you pass parameters using Process Scheduler, your SQR only needs the
appropriate INPUT statements to store those parameters (no PeopleCode
required!).  The "SQR Report" process type includes the process instance,
oprid and run control id as sqr parameters so those will always be first.
And in your SQR there should be a delivered procedure named something like
get-run-control-parameters which will kick off three input statements to
pick up those 3 parameters.  If you add more sqr parameters in the process
definition just add additional INPUT statements that will get kicked off
after get-run-control-parameters to pick up those.

As far as pros/cons for using SQR parameters (which are your run control
record's fields)  vs run control records.. . I can't think of any major
advantage or disadvantage for either method.  They're basically two methods
for capturing input.  I think PeopleSoft's norm is to use run control
records.
> -----Original Message-----
> From: Hari Haran [SMTP:harispssqr@YAHOO.CO.IN]
> Sent: 1 March 2001 7:30 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Thanks a lot- passing parameters- help
>
> Hi friends,
> Thanks a lot for suggesting me a good book  and also
> helping me out with passing parameters using run
> control record in peoplesoft.
>
> I have successfully created a run_cntl_id for me and
> passed parameters(field) and received that in sqr by
> suitably modifying the given API's.
> Now i am trying out passing parameters using process
> scheduler(i.e. using sqr parameters).
> I have filled in the field as follows
>
> :tablename.fieldname
>
> I am trying to pass the field value in buffer to
> process scheduler.
>
> I have included $variable in my sqr program to receive
> the passed value from process scheduler.
>
> Is there anything i need to do from peoplecode side ?
> Is there any specific basis on which to decide whether
> to use run control records or to use bind variables in
> process scheduler(sqr parameters)?
> Kindly help me out.An example would be ideal.
>
> Thanking you in advance.
> Hari.
>
>
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.in address at http://mail.yahoo.co.in