PeopleSoft SQL API for Batch COBOL

The purpose of PeopleSoft SQL API is to enable PeopleSoft batch COBOL programs to run SQL commands and control the SQL environment.

Features

These are the features:

  • Predefined SQL statements are stored outside of the COBOL program and are identified by name.

  • SQL statements are executed dynamically.

  • Multiple (up to 254) SQL cursors are available.

  • The SQL interface is invoked from the application COBOL program from CALL with parameters.

  • Support is provided for SQL statements built dynamically by COBOL programs.

Functions

These are the functions:

  • Process Select Statement.

  • Fetch Row.

  • Process Update Statement: DELETE, INSERT, and UPDATE.

  • Commit Run Unit.

  • Clear Common Statement (after program CANCEL).

  • Disconnect Cursor.

  • Disconnect All Cursors.

  • Process Fatal Application Error.