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

Why db2 is called db2?

591


Define sqlca.

647


what is the role of the cursor in db2?

640


What is a db2 schema?

762


How many databases are there?

590






Which is faster delete or truncate?

675


Mention some fields that are a part of sqlca.

600


Why select is not preferred in embedded sql programs?

713


Explain about cursor stability?

621


Define check constraint.

644


Define declaration generator (dclgen).

665


What is package in db2 mainframe?

557


What is a bind card?

679


What is a bind in db2?

592


What is schema in db2?

575