How can you quickly find out the number of rows updated
after an update statement?
Answer / vamshi
check for the value is in sqlerrd(3). it contains the no.
of rows updates.
| Is This Answer Correct ? | 23 Yes | 0 No |
what is diffrence b/w file-aid tool and file-aid utility???
What is the error code -803 ?
What is schema in db2?
What is cursor?
What is the difference between CS and RR isolation levels?
wht are the restrictions for union ?
How does the processing of a correlated subquery differ from a non correlated subquery?
Who uses db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How will fetch last 5 rows from table in db2
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Explain what are the various isolation levels possible?