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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How do you define a correlated name?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
The only place of VSAM KSDS in DB2 is?
What are PACKAGES ?
Define check constraint.
What is meant by repeatable read?
Can you tell me how can you find out the # of rows updated after an update statement?
Outputs of explain are with matchcols = 0. What does this signify?
What is explain in db2?
What is a LIKE table and how is it created?
Can SQL statements/queries be included in a copybook?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!