when i am trying to update a table having 1000 rows. the
program abends.how we will come to know the last successful
updated row was. we are not using any commit operations

Answer Posted / guest

check SQLERRD(3) from SQLCA copybook.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What db2 400?

795


Are views updateable?

730


Why do we use cursor?

681


What are catalog tables in db2?

685


How to find the number of rows in a db2 table?

744






Explain various types of locks in db2?

776


Explain what are the various isolation levels possible?

675


List out the data types available.

797


What are host variables in db2?

707


How do I import data from excel to db2?

702


What is runstats db2?

665


What are bind parameters in db2?

690


How to create db2 table in mainframe?

736


What is the use of db2?

681


What do you mean by rollback?

651