COBOL Stored Statements



Problem:

Application Program Failed

Action Type : SQL SELECT

In Pgm Section : SQLRT: SQL-STMT-GET

Error Message : Stored Statement PSPCKSGD_S_PRMPGRP not found

Stored Stmt : PSPCKSGD_S_PRMPGRP

Viewing the Statement
SELECT * FROM PS_SQLSTMT_TBL
WHERE PGM_NAME || ‘_’ || STMT_TYPE || ‘_’ || STMT_NAME = ‘PSPCKSGD_S_PRMPGRP’

In my case, the statement did not exist. So, I ran the DMS Script through data mover:
<PS Home>/src/cbl/base/pspcksgd.dms

Resources
Re: GLPJEDIT error.


Share