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
Who uses db2?
What is cursor with hold option in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Before you give the explain statement, what are the prerogatives?
What is cascading rollback?
What does db2 blu stand for?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
define clustering index.
Can one database have multiple instances?
What is copy pending status in db2?
Explain what are the various isolation levels possible?
What are host variables in db2?
What is db2 purescale?
What is a db2 schema?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?