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
What is the physical storage length of date data type?
What is the default page size of buffer pools?
Outputs of explain are with matchcols = 0. What does this signify?
What does db2 stand for?
Define check constraint.
What is sqlca?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is cloudant database?
How to access db2 tables in mainframe?
define clustering index.
Can you tell me how can you find out the # of rows updated after an update statement?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is load replace in db2?
can we view the access paths created by dbrm ? how ? thx