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
Can we insert update delete in view?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How is deadlock resolved?
How to find the maximum value in a column in the db2 database?
What is meant by dclgen?
List out the three types of page locks that can be held.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is table space in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is the difference between dbm cfg and db cfg file in db2 ?
Explain various types of locks in db2?
What is ibm db2 client?
What is a system catalog table in db2?
What is the maximum No of rows per page?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?