Page 1 of 1

SQL operation in sysibm.sysstmt

PostPosted: Tue Jan 10, 2012 9:50 pm
by kiranmayi
Can any one help me in finding whether statement contains the SQL operations(READ,UPDATE,DELETE) from the TEXT column of the SYSIBM.SYSSTMT table?

Re: SQL operation in sysibm.sysstmt

PostPosted: Tue Jan 10, 2012 10:42 pm
by Akatsukami
There 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.