Calling COBOL from SQR

["Gayle.Hook" <Gayle.Hook@YELLOWCORP.COM>]

Hi All,

I'm using SQR v 4.3.2, PeopleTools 7.56, Oracle 8, Sun, NT workstation.

Does anyone know if there is a peoplesoft function that can be called to get
the next process instance number within a SQR program...  I'm trying to Call
a COBOL Program from a SQR using the process scheduler with the 'Call System
using' command.  I am using a select with in the SQR to get my parms to pass
to the COBOL. I have a need to execute the COBOL program in a batch that is
why I have chosen this method.  I want to get the next process instance #
that is available, then within my program assign that number to the COBOL
process that I'm calling from the command line.  I do have my SQR calling
the COBOL for 6 instances (using a loop) and it is working but I'm
hardcoding the starting value.
Each time I run I have to change the start value as NOT to get a 00805
ORA-00001unique constraint error.
I would be interested in getting anyones help especially if you have a SQR
program calling COBOL.
THANKS!!!

Gayle A Hook
Programmer Analyst II
(913) 344-3729
Gayle.Hook@yellowcorp.com