DYNAMIC SQL REPORTING IN BATCH

Document ID : KB000091711
Last Modified Date : 11/05/2018
Show Technical Document Details
Issue:
We collect dynamic sql and see it. But we need report it in Batch but can't figure out. We see these options for Batch reports: * SPECIFY THE REPORT TO GENERATE. VALID REPORTS ARE; PLAN, PROG, SQL, * EXCP, AND SQLE. Which one to choose?
Resolution:
REPORT Generates reports of the collected data. The following report types are valid: DYNT (Dynamic SQL Activity Report) EXCP (Exception SQL Report) KEYDYNT (Dynamic SQL Activity Report by Key) KEYPLAN (Plan Activity Report by Key) KEYPROG (Package/DBRM Activity Report by Key) PLAN (Plan Activity Report) PLANDYNT (Plan Dynamic SQL Activity Report) PROGDYNT (Program Dynamic SQL Activity Report) PROG (Package/DBRM Activity Report) SQL (SQL Statement Activity Report) SQLE (SQL Error Report)