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 / girish kumar

if u want to update ur changes to the database, posible when the commit is executed or when the program successfully executed. none other any situation database will not update.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum No of rows per page?

626


How would the varchar column remarks defined?

635


How will you return the number of records in table?

514


What is a page in db2?

610


What are the bind parameters ibm db2?

622






What is the function of logging in the db2 database?

640


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

658


What is ibm db2 used for?

598


What are the contents of dclgen?

652


Can you tell me how can you find out the # of rows updated after an update statement?

610


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7508


How to find primary key of a table in db2?

611


Which component is used to execute the sql statements?

619


Why select is not preferred in embedded sql programs?

711


What is image copy in db2?

568