View previous topic :: View next topic
|
Author |
Message |
rohanthengal
Active User
Joined: 19 Mar 2009 Posts: 206 Location: Globe, India
|
|
|
|
Hello friends,
Pls help me out in this:
I want to find out the count of the number of records being updated in my table during execution of SQL statements.
Is ther any other way other than taking help of count ? I mean automatically to find out the number of record updated in DB2.
Regards,
Rohan |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
the SQLCA field SQLERRD(3) contains the number of UPDATED, DELETED, or INSERTED rows for each UPDATE, DELETE, or INSERT SQL invoked. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
Back to top |
|
|
|