when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was
Answer Posted / prachi
check for sqlca.sqlerrd[2] -
as it indicates the number of rows processed before the
error occurred in a multirow INSERT, UPDATE, or DELETE
statement.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How do I delete a table in db2?
Explain packages.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How can we read records for specific member in CL? AND rpg?
What are the benefits of using the db2 database?
What is query_cache_limit?
What are types of indexes?
Mention some fields that are a part of sqlca.
What is deadlock in db2?
What is dbrm? What it contains?
What is package in cobol db2?
What is the physical storage length of the data types date, time, and timestamp?
What is runstats utility in db2?
What is the difference between drop table and delete table?
Mention the definition of cobol in varchar field.