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 is reorg?

610


What is db2 instance?

585


what is a corelated subquerry?

647


Why cursor is used in db2?

565


What is concurrency?

695






What is db2? Explain.

593


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1225


What is blu acceleration in db2?

594


Is ibm db2 open source?

573


Define buffer pool.

616


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

694


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

649


Give the name of some fields form sqlca.

607


Mention the location where the output received from explain statement is stored.

622


What is db2 plan table?

608