This section provides an overview of COBOL API and Meta SQL and discusses how to:
Run COBOL outside of Process Scheduler.
Disable persistent cursors.
Understanding COBOL API and Meta SQL
PTPSQLRT is the COBOL API program called by application COBOL programs to prepare and execute dynamic SQL statements. The program fetches SQL statements—known as stored SQL statements—from PS_SQLSTMT_TBL, then processes them using dynamic SQL. (Prepares and Executes.) Except for PTPSQLRT, PeopleSoft application COBOL programs do not contain a direct DB2 UDB interface and therefore need only be compiled and link-edited.
Stored SQL statements contain META SQL statements mainly to support date and time functions, for example:
Select %currentdatetimeout from PSLOCK ;
PTPSQLRT resolves META SQL statements by calling PTPSQLGS which translates the META SQL function into DB2 UDB syntax. Stored statements are delivered in directory \SRC\CBL\BASE of the installation file server.
Running COBOL Outside of Process Scheduler
COBOL jobs may run outside process scheduler by specifying a 0 (a numeric zero) for the process instance, as shown in the fourth parameter below:
//PARMFILE DD * %OPRID% %RUNID% N 0 N N Y
Sample COBOL JCL is provided in HLQ.PPVVV.JCLLIB(CBLSAMP). Be aware that some application processes are designed to run only through Process Scheduler.
Disabling Persistent Cursors
The z/OS version of the COBOL API program called PTPSQLRT uses Cursor With Hold by default.
In PeopleSoft terminology, the field CURSOR_SW in PTPSQLRT is used to define Persistent Cursors (CURSOR-PERSISTENT) and Normal Cursors (CURSOR-NORMAL). CURSOR-PERSISTENT adds the WITH HOLD keyword to SQL selects in DB2 UDB. This maintains cursor position after a commit, so that repositioning (reopening and re-fetching) does not need to occur.
The DB2 UDB version of PTPSQLRT is shipped with Persistent Cursors enabled. If you don’t want to use this feature, you can disable it by editing PTPSQLRT as follows:
To disable Cursor with Hold (i.e. Persistent Cursors):
Edit PTPSQLRT and do a “find” on ‘CURSOR WITH HOLD’ => f ‘CURSOR WITH HOLD’.
For each of the 254 pairings of Cursor statements, remove the asterisk (*) from line that creates the cursor without the WITH HOLD option (column 7) and place it in column 7 of the line that creates the cursor with the WITH HOLD option above it. For example:
EXEC SQL DECLARE CURSOR_01 CURSOR WITH HOLD FOR SQLSTMT_01 * CURSOR FOR SQLSTMT_01 END-EXEC
EXEC SQL DECLARE CURSOR_01 * CURSOR WITH HOLD FOR SQLSTMT_01 CURSOR FOR SQLSTMT_01 END-EXEC