No Subject

[Michael Reel <mreel@CONCENTRIC.NET>]

Wasserberger, Lawrence H. wrote:

> Using SQR3 with Informix, is there an "ëasy" way to determine if the
> program is being run under the control of the Process Scheduler or
> directly under SQRW?

Well, all programs written in SQR for PeopleSoft generally have the
prompt"Press Enter" when the program starts to run.  Actually what you
are entering is
the process instance.  If this value is not equal to NULL then it will
give the same
prompt when it asks you for the operator id and run control id.

The point is PeopleSoft SQRs tend to use that as the check to see if it
was run
through the process scheduler or if it was run through a direct call to
the sqrw program.

Here is the algorithm.

Prompt for process instance
if process instance is NULL
   Ask for any user inputted values
else
   prompt for operator id and run control id
   get values passed in from PeopleSoft from the run control table
end

You could set a flag inside of the if statement to tell you how the SQR
was initiated.

Good luck

Michael Reel
DataStudy, Inc.
(201) 540-4611