return codes

[Bruce Kelling <Bruce_Kelling@ADVANTECHSOLUTIONS.COM>]

You can find SQL error return values in SQLERR.sqc, and how the process
monitor gets updated from STDAPI.sqc and associated  sqc's.

As far as passing return values to Autosys, you can do this by writing your
own sqc procedures.  One technique is for your Autosys script to create a
control file.  In SQR, create a procedure that uses the SQL error codes or
PRCSDEF.sqc values to write to the control file. Then in your Autosys
script, after the sqr is run, read the control file.  Your AutoSys script
can then react based on the values.

Bruce




-----Original Message-----
From: Jason Sekkes (SB) [mailto:Jason.Sekkes@STROEHMANN.COM]
Sent: Wednesday, November 07, 2001 11:54 AM
To: SQR-USERS@list.iex.net
Subject: return codes


Does anyone know if SQR has return codes that can be passed to a software
package such as CA's Autosys?  Also does anyone know how the Peoplesoft
process monitor gets its return codes from specific programs?

Jason Sekkes
Programmer Analyst
Stroehmann Bakeries, LC
* (610)-631-8214
*    Jason.Sekkes@Stroehmann.com