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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: