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 / sesha

If there is no commit is mentioned,processed records are
lost when an abnormal end occurs.Rows are inserted,
updated,deleted in a table, those changes will be
lost in case of abend.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dpf in db2?

753


What is netezza database?

664


What parameters are used to control the free space in DB2?

726


Why do chiropractors use drop table?

777


What is multi row fetch in db2?

677






What is the syntax for FETCH in DB2 ?

767


What is difference between alias and synonym in db2?

726


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

668


What is dclgen in db2?

777


What is catalog database in db2?

749


Mention the definition of cobol in varchar field.

776


What is db2 purescale?

645


What is reorg?

694


What is universal database?

717


Define db2 and its databases?

708