Friday 24 May 2013

COBOL Error: Stored Statement PSPCKSGD_S_PRMPGRP not found

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

1 comment: