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: 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: 669
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: 6968
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 Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm


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