SQL operation in sysibm.sysstmt
Posted: Tue Jan 10, 2012 9:50 pmCan any one help me in finding whether statement contains the SQL operations(READ,UPDATE,DELETE) from the TEXT column of the SYSIBM.SYSSTMT table?
IBM Mainframe Forum
Mainframe Technical Support Forums
https://www.ibmmainframeforum.com/
SQL operation in sysibm.sysstmt
Page 1 of 1
Posted: Tue Jan 10, 2012 9:50 pmRe: SQL operation in sysibm.sysstmt
Posted: Tue Jan 10, 2012 10:42 pmThere is no "SQL statement READ" as you, who allege to know DB2, should know. Otherwise, search the TEXT column of those SYSSTMT rows that meet your criteria, using the language-appropriate facility.