Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1281
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: 688
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: 6970
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 The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
No new posts Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 8 Wed Nov 15, 2017 4:27 pm
No new posts Increment number for every group of r... srajendran2 DFSORT/ICETOOL 7 Thu Nov 09, 2017 10:31 pm
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us