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 |
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is meant by explain?
How many types of page locks can be held in db2?
Explain about rct in db2?
Is the primary key a clustered index?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Why do we need reorg in db2?
What is meant by concurrency?
When DB2 connection fails, will online program work or give errors.
What are some characteristics of columns that benefit from indexes?
Explain transactions, commits and rollbacks in DB2.
How to execute stored procedure in db2 command editor?