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
What do you mean by between and in? Is between inclusive of specified range values?
Define db2 and its databases?
What does db2 mean?
What is dbrm? When it will be created?
How do I copy a table in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How can you quickly find out the # of rows updated after an update statement?
What db2 400?
What is the use of db2?
What is the advantage in De-normalizing tables in DB2?
What is sqlca’s maximum length?
What is dbrm? What it contains? When it will be created?
Explain in detail about buffer manager and its functionalities?
How to check last update on table in db2?
What is cascading rollback?