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
 
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: 42
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: 2173
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: 42
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: 6970
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: 42
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: 2173
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: 1790
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
No new posts No of job count for an milestone job sen_1983us CLIST & REXX 7 Tue Jul 02, 2019 7:34 am
No new posts Deleting rows using utility from DB2 ... manugeorge2004 DB2 2 Tue Jun 25, 2019 6:41 pm
No new posts Mainframe to linux file count mismatch shreya19 All Other Mainframe Topics 4 Thu Jun 13, 2019 9:49 pm
No new posts Cursor result set being updated??? John Poulakos DB2 5 Tue May 28, 2019 10:46 pm
No new posts count the number of records from diff... janmejay CA Products 4 Mon Mar 25, 2019 11:29 pm

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