SQL statements in COBOL programs

Advanced COBOL for Structured and Object-Oriented Programming (3rd Edition)

This is the extract from peoplebooks:

Nonstandard SQL Commands

With PeopleSoft Data Mover, you can also use the following nonstandard SQL commands created by PeopleSoft: STORE and ERASE. Use the commands to change COBOL SQL statements in PS_SQLSTMT_TBL.

Example:if you see 'ZZZZZZ_S_PYDATA' in any cobol program, look for a dms script with name ZZZZZZ
and inside that you would see a 'SELECT (S) ' statement.

murachs mainframe cobol By Murach, Mike/ Prince, Anne/ Menendez, Raul

No comments:

Post a Comment