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 diffrence b/w file-aid tool and file-aid utility???

4177


What are union and union all?

537


How do I create a view in db2?

600


How many databases are there?

590


What is the difference between cursor and select statement?

613






what is utility for parm lib

1873


Mention data types used in db2 ?

675


How do you find the maximum value in a column in db2?

648


What does a deadlock mean in DB2?

651


What is the physical storage length of the data types date, time, and timestamp?

604


What is db2 and what is the use of db2 optimizer?

650


What is check constraint in db2?

603


Mention the definition of cobol in varchar field.

688


What is the use of runstats in db2?

575


Is it possible using max on a char column?

604