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
 

 

Count the number of rows updated or deleted or inserted.

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

New User


Joined: 03 Dec 2012
Posts: 35
Location: India

PostPosted: Tue Jul 14, 2015 7:57 pm    Post subject: Count the number of rows updated or deleted or inserted.
Reply with quote

Hi All,

Is there a provision in DB2 tables that one of the column acts as a automatic counter. So that it counts the number of rows inserted, updated or deleted in a particular table. I don't want to check SQLCA copybook field.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Tue Jul 14, 2015 8:26 pm    Post subject:
Reply with quote

This may be you are interested in..

http://ibmmainframes.com/about55499.html
Back to top
View user's profile Send private message
Chetan Kumar

New User


Joined: 03 Dec 2012
Posts: 35
Location: India

PostPosted: Wed Jul 15, 2015 3:29 pm    Post subject:
Reply with quote

Thanks for the link. But I didn't find it useful nor get any clarity on the stuff I'm looking.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Wed Jul 15, 2015 5:06 pm    Post subject:
Reply with quote

Chetan Kumar wrote:
I don't want to check SQLCA copybook field.


Chetan,
I stopped posting negtive responses several years ago,
but the above comment really put my resolve to the test.

please, tell me why you do not want to use a field that is allready
definined
and
populated
upon return from db2?
And why you would want to incur another CALL to DB2 to determine something that is already at hand.
Back to top
View user's profile Send private message
Chetan Kumar

New User


Joined: 03 Dec 2012
Posts: 35
Location: India

PostPosted: Wed Jul 15, 2015 7:55 pm    Post subject:
Reply with quote

Hi Dick,

The counter is already associated with the DB2 Table. There is no need for any coding or additions to DB2 table. Basically I wanted to know how to figure out or how to locate the auto counter that is already associated with the table.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Wed Jul 15, 2015 8:34 pm    Post subject:
Reply with quote

Quote:
Thanks for the link. But I didn't find it useful nor get any clarity on the stuff I'm looking.


What is that now you looking for? Why do you not want to look for IC?

Quote:
I don't want to check SQLCA copybook field


Why? What is it that restricts you to use?

Quote:
The counter is already associated with the DB2 Table. There is no need for any coding or additions to DB2 table. Basically I wanted to know how to figure out or how to locate the auto counter that is already associated with the table.


What counter? what is auto counter?

Have you talked to DBA yet ?
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Thu Jul 16, 2015 4:43 pm    Post subject:
Reply with quote

Chetan Kumar wrote:
The counter is already associated with the DB2 Table.

Except that there isn't one, and if you thought about the matter for two seconds you'd realize why there isn't. You're just going to have to do some actual work.
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
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm
No new posts Row-Numbers of distinct rows? Auryn DB2 1 Thu Oct 20, 2016 4:38 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts Get Record count in summary record fo... Atul Banke DFSORT/ICETOOL 21 Fri Sep 23, 2016 4:17 pm
No new posts Sequence number add in SORT pshongal SYNCSORT 3 Fri Sep 02, 2016 3:32 pm


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