SQL operation in sysibm.sysstmt

IBM's flagship relational database management system

SQL operation in sysibm.sysstmt

Postby kiranmayi » Tue Jan 10, 2012 9:50 pm

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?
Posts: 2
Joined: Tue Jan 10, 2012 9:37 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQL operation in sysibm.sysstmt

Postby Akatsukami » Tue Jan 10, 2012 10:42 pm

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Global moderator
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Return to DB2


  • Related topics
    Last post