|
View previous topic :: View next topic
|
| Author |
Message |
Chetan Kumar
New User
.jpg)
Joined: 03 Dec 2012
Posts: 46
Location: India
|
|
|
|
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 |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
| Back to top |
|
|
Chetan Kumar
New User
Joined: 03 Dec 2012
Posts: 46
Location: India
|
|
|
|
| Thanks for the link. But I didn't find it useful nor get any clarity on the stuff I'm looking. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| 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 |
|
|
Chetan Kumar
New User
Joined: 03 Dec 2012
Posts: 46
Location: India
|
|
|
|
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 |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
| 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 |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1787
Location: Bloomington, IL
|
|
|
|
| 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 |
|
|
|
|
