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 is deadlock resolved?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Explain an outer join?
What is a db2 collection?
What is difference between alias and synonym in db2?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is an instance in db2?
How does DB2 determine what lock-size to use?
How and when does the db2 enforces the unique key?
What is the maximum size of a char data type in db2?
What are the contents of a DCLGEN?
Can we insert update delete in view?