PS_SQLSTMT_TBL is the record to find the SQL's being used in a COBOL
There are 4 fields in this record where PGM_NAME is the field that gives the COBOL name and STMT_TEXT is the field that stores the SQLs used in the COBOL.
Name Null? Type
----------------------------------------- -------- ----------------------------
PGM_NAME NOT NULL VARCHAR2(8)
STMT_TYPE NOT NULL VARCHAR2(1)
STMT_NAME NOT NULL VARCHAR2(7)
STMT_TEXT NOT NULL LONG
There are 4 fields in this record where PGM_NAME is the field that gives the COBOL name and STMT_TEXT is the field that stores the SQLs used in the COBOL.
Name Null? Type
----------------------------------------- -------- ----------------------------
PGM_NAME NOT NULL VARCHAR2(8)
STMT_TYPE NOT NULL VARCHAR2(1)
STMT_NAME NOT NULL VARCHAR2(7)
STMT_TEXT NOT NULL LONG
No comments:
Post a Comment