Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Number of UPDATE in a DB2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
balubhat

New User


Joined: 04 Oct 2005
Posts: 19
Location: Singapore

PostPosted: Fri Jun 18, 2010 12:01 pm    Post subject: Number of UPDATE in a DB2 program
Reply with quote

Hi

Does any of the SYSIBM table provide the total number of UPDATE/DELETE/INSERT/SELECT in a program?

Basically, without going into the program, is it possible to know how many UPDATE sql query are there a given program? And on which table also...

Pls let me know if any of you knows about it.

I tried to find in SYSIBM.SYSPAKSTMT but it doesn't give that.


Thanks!
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Fri Jun 18, 2010 1:04 pm    Post subject:
Reply with quote

No
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 660
Location: Pennsylvania

PostPosted: Fri Jun 18, 2010 7:05 pm    Post subject:
Reply with quote

This is an UNTESTED Query for you to start with.

I am sure you can tailor it to fit your needs:

Code:

SELECT GRANTEE,
       TTNAME,
       DELETEAUTH,
       INSERTAUTH,
       SELECTAUTH,
       UPDATEAUTH,
FROM SYSIBM.SYSTABAUTH
WHERE GRANTEE = MY-PROGRAM
    AND (DELETEAUTH = 'Y'
     OR  INSERTAUTH = 'Y'
     OR  SELECTAUTH = 'Y'
     OR  UPDATEAUTH = 'Y')
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 18, 2010 7:12 pm    Post subject:
Reply with quote

you could also do a SuperC Search
on your DBRM library,
search keys would be INSERT, DELETE, SELECT, UPDATE
then you could sort the results either by program or table.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm
No new posts what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts GDG version number PANDU1 JCL & VSAM 4 Sat Mar 04, 2017 8:28 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us