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


Please Help Members By Posting Answers For Below Questions

Explain what are the various isolation levels possible?

675


What is a db2 collection?

688


How does coalesce work?

669


What does db2 plan contain?

655


How to rename a table in DB2 ?

711






What is bind and rebind in db2?

737


Can we update view in db2?

651


What are the rules for db2 programming?

728


What is the maximum size of a char data type in db2?

672


How do you pull up a query which was previously saved in qmf?

777


What is the max length of sqlca?

839


what is db2 restart?

1778


What do you mean by cursor?

683


Explain in brief how does db2 determine what lock-size to use?

674


What is release/acquire in bind?

733