How can you quickly find out the number of rows updated
after an update statement?
Answer Posted / vamshi
check for the value is in sqlerrd(3). it contains the no.
of rows updates.
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
Comment whether the cursor is closed during commit or not.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is ibm db2 used for?
Name the various locking levels available?
What is null indicator in db2?
What is dclgen in db2?
How do I create a view in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How to test SQL -911 error while developing COB-DB2 program
How can the duplicate values be eliminated from db2 select?
What is the syntax for creating a table in the db2 database?
What is access path in db2?
Is it possible using max on a char column?
How many types of page locks can be held in db2?