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 |
What is tablespace?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
what is a corelated subquerry?
How can you find out the # of rows updated after an update statement?
can we view the access paths created by dbrm ? how ? thx
what are bind concepts in db2 cobol?
What are the various isolation levels possible?
What is collection in db2 bind?
how to check the table is empty or not?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is ibm db2 database?