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

Re: SQL operation in sysibm.sysstmt

 

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
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post