Interested to Buy Any Domain ? << Click Here >> for more details...
what happend with out using Commit,when closing cursor and
program?
- 5 Answers
- 14996 Views
- CSC, I also Faced
- E-Mail Answers
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 are the various data types available in db2?
Explain correlated sub-queries.
What is the role of union all and union
What is null indicator in cobol db2?
Mention the various locks that are available in db2.
List out the data types available.
Can one database have multiple instances?
What are the 2 sqlcodes that are returned?
Define declaration generator (dclgen).
How can deadlocks be resolved?
What is database reorganization?
What is the difference between using bind () and rebind () methods of naming class?
What is load utility in db2?
What is db2 catalog database?
What is the use of value function?
