Batch SQL Text report example
The following SYSIN statement is used to generate the Batch SQL Text report, listing long SQL statements (over 32K).
REPORT(NAME(SQMBTEXT))
Batch SQL Text report (SQMBTEXT)
1 SQMBTEXT: BATCH SQL TEXT REPORT 03/23/11 13:42:02 PAGE 1
+ TIME: 03/19/11 10:42:40.922813 KEY: FA5D00B15D338C67EF1B
STATEMENT TYPE: OPEN ( STATIC )
PLAN: ACT101DM PROGRAM: ACSBQPI SECTION: 5 STATEMENT: 658
DECLARE PIPIRCRSR CURSOR FOR
SELECT A.*
FROM SYSIBM.SYSPACKLIST A
WHERE A.PLANNAME = :H
AND (A.LOCATION = ' '
OR A.LOCATION = '*')
ORDER BY PLANNAME, SEQNO
FOR FETCH ONLY
+ TIME: 03/19/11 10:42:40.923080 KEY: FA5D00B15D338C67EF1B
STATEMENT TYPE: FETCH ( STATIC )
PLAN: ACT101DM PROGRAM: ACSBQPI SECTION: 5 STATEMENT: 664
DECLARE PIPIRCRSR CURSOR FOR
SELECT A.*
FROM SYSIBM.SYSPACKLIST A
WHERE A.PLANNAME = :H
AND (A.LOCATION = ' '
OR A.LOCATION = '*')
ORDER BY PLANNAME, SEQNO
FOR FETCH ONLY
+ TIME: 03/19/11 10:42:40.922813 KEY: FA5D00B15D338C67EF1B
STATEMENT TYPE: OPEN ( STATIC )
PLAN: ACT101DM PROGRAM: ACSBQPI SECTION: 5 STATEMENT: 658
DECLARE PIPIRCRSR CURSOR FOR
SELECT A.*
FROM SYSIBM.SYSPACKLIST A
WHERE A.PLANNAME = :H
AND (A.LOCATION = ' '
OR A.LOCATION = '*')
ORDER BY PLANNAME, SEQNO
FOR FETCH ONLY
+ TIME: 03/19/11 10:42:40.923080 KEY: FA5D00B15D338C67EF1B
STATEMENT TYPE: FETCH ( STATIC )
PLAN: ACT101DM PROGRAM: ACSBQPI SECTION: 5 STATEMENT: 664
DECLARE PIPIRCRSR CURSOR FOR
SELECT A.*
FROM SYSIBM.SYSPACKLIST A
WHERE A.PLANNAME = :H
AND (A.LOCATION = ' '
OR A.LOCATION = '*')
ORDER BY PLANNAME, SEQNO
FOR FETCH ONLY
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*