|
Snapshot Level Application Dynamic SQL DCS Statement |
Logical Data Grouping stmt dynsql dcs_stmt |
Monitor Switch Statement Basic Statement |
|
Resettable |
No |
|
|
Event Type Statement |
Logical Data Grouping stmt_event |
|
|
Element Name Element Type |
stmt_text information |
Description: This is the text of the dynamic SQL statement.
Usage: For application snapshots, this statement text helps you identify what the application was executing when the snapshot was taken, or most recently processed if no statement was being processed right at the time the snapshot was taken.
For dynamic SQL statements, this element identifies the SQL text associated with a package.
For event monitors, it is returned in the Statement event record for all dynamic statements.
See "Section Number" for information on how to query the system catalog tables to obtain static SQL statement text that is not provided due to performance considerations.