what happend with out using Commit,when closing cursor and
program?
- 5 Answers
- 13691 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
Explain the function of data manager.
What are the various isolation levels possible?
What is the difference between drop table and delete table?
What is the physical storage length of timestamp data type?
Can there be more than one cursor open for any program?
How to resolve deadlock issue
What is the connection string to connect to the DB2 Database ?
Explain what are the various isolation levels possible?
Before you give the explain statement, what are the prerogatives?
can all users have the privilage to use the sql statement select * (dml)?
Define predicate?
What is the use of commit in db2?
Discuss about db2 bind?
What is difference between isnull and coalesce?
Which is faster delete or truncate?
