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 |
What is db2 bind process?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
What is access path in db2?
What is db2? Explain.
what is differnece between DROP TABLE & DELETE TABLE .
How many sub queries can you combine together ?
Which catalog tables contain authorization information?
What is dbrm? What it contains?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What are the contents of a DCLGEN?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
Describe the elements of the SELECT query syntax?