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
- 3 Answers
- 7299 Views
- IBM, I also Faced
- E-Mail Answers
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 the difference between join and union?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What is consistency token 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.
what is the difference between normal select query and currosor
How do you check for a null value in a db2 column?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is cursor in dbms?
How to fetch the last row from the table in SQL (db2)?
what is different three logs in DB2?
What does a deadlock mean in DB2?
How to find schema of a table in db2?
COBOL 
