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 |
Name some fields from SQLCA.
What are the three lock types?
How do you do the EXPLAIN of a dynamic SQL statement?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What is the difference between Where and Having Clause
What does the RUNSTATS Utility do?
What is a cursor and what is its function?
What is deadlock in db2?
What is the physical storage length of date data type?
What is the maximum size of a char data type in db2?
how to check the table is empty or not?
How we create a tables in db2,what is the process/syntax to create a table with example plz?