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

What is the role of the data page in the db2 database?

766


Mention the downsides of page level lock.

905


What is dbrm in db2 database?

775


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2265


Which isolation level provides highest data integrity?

803


How does cobol compile db2 program?

802


What is node in db2?

797


What is a trigger in the db2 database?

783


What is image copy in db2?

745


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

766


Why select is not preferred in embedded sql programs?

916


what are bind concepts in db2 cobol?

812


Define declaration generator (dclgen).

863


What is the difference between cursor and select statement?

826


Before you give the explain statement, what are the prerogatives?

759