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 |
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
How do I delete a column in db2?
Name some fields from SQLCA.
Can we install 2 different versions of Db2 on same mainframe?
What is ibm db2 used for?
Give a brief description of db2 isolation levels?
How are write I/Os from the buffer pool executed?
What are db2 objects?
What information is used as input to the bind process?
wht is d/f between union and joins ?
What is a recovery log?