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 |
How do you simulate the explain of an embedded sql statement in spufi/qmf?
wht happens if we close cursor with cursor with hold option?
What do you mean by commit and rollback?
When is the skeleton cursor table created?
How can you quickly find out the number of rows updated after an update statement?
What is blu acceleration in db2?
What is null indicator in db2?
What is the function of the Data Manager?
Explain about cursor stability?
When reorg is used?
What is an intent lock?
Can we install 2 different versions of Db2 on same mainframe?