what happend with out using Commit,when closing cursor and
program?
Answer Posted / guna
If there is no commit while closing cursor or a program,
processed records are lost when an abnormal end occurs.
Say, if due to the execution of the program some rows are
inserted/deleted/updated in a table, those changes will be
lost.
It is a better practice to give commit after every
insertion/updation queries and before terminating a
program.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is commit in db2?
What is database reorganization?
What is the difference between plan and package in db2?
What is ibm db2 client?
What is the maximum size of a char data type in db2?
Which is faster delete or truncate?
Explain about cursor stability?
What is dclgen (declaration generator)?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Is db2 free?
Outputs of explain are with matchcols = 0. What does this signify?
Explain the function of data manager.
What is the usage of open cursor command?
What does db2 stand for?
What is the syntax for creating a table in the db2 database?