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 is blu acceleration in db2?
what is the responsibility of the construction superintendent
What is iseries database?
Is schema the same as database?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How to check sequence on a table in db2?
What is check constraint. Explain with example.
What is db2? Explain.
How can deadlocks be resolved?
If I have a view which is a join of two or more tables, can this view be updateable?
When reorg is used?
Outputs of explain are with matchcols = 0. What does this signify?
What is cursor stability in db2?
What are the rules for db2 programming?
How to fetch the last row from the table in SQL (db2)?