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 |
Where is the output of EXPLAIN stored?
How do I change the column size in db2?
Which is faster delete or truncate?
how to fetch first 100 rows in db2
What is db2 catalog database?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
where can we use index and subscript ? with example ?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
explain about index with examples
What is the physical storage length of date data type?
What is the difference between group by and order by?
My SQL is not performing well. Describe how will you fine tune it?