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 |
Is it possible using max on a char column?
Name the various locking levels available?
How to fetch the last row from the table in SQL (db2)?
What is bind package and plan in db2?
What is bind and rebind in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Q3. How will you fetch duplicate values from a DB2 table?
can you use symbolic parameters in JOB?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is the difference between Primary key and unique index?
What is a plan and package in db2?