What is meant by AUTO COMMIT?
Answers were Sorted based on User's Feedback
Answer / s
When an application program executes successfully or when
you use SPUFI to issue SQL, a commit is issueed
automatically.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / m4io
"excutes" should be "ends"
thus :
When an application program ENDS successfully or when
you use SPUFI to issue SQL, a commit is issueed
automatically.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mako
db2 list command option using c off
or
db2 list command option using c on
| Is This Answer Correct ? | 1 Yes | 1 No |
What is universal database?
how to resolve -811 error. give clear explination
what are stage one indexable predicates?
What is the function of logging in the db2 database?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
How to see the structure of db2 table??
What is explain in db2?
How to update more then one record using update?
When is the authorization check on DB2 objects done - at BIND time or run time?
What are the three types of page locks that can be held?
When reorg is used?
What is the difference between group by and order by?