|
Related Questions |
View Answer |
|
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)
|
View Answer
|
|
How do you do the EXPLAIN of a dynamic SQL statement?
|
View Answer
|
|
EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?
|
View Answer
|
|
Where is the output of EXPLAIN stored? ?
|
View Answer
|
|
What do you need to do before you do EXPLAIN?
|
View Answer
|
|
What is EXPLAIN? ?
|
View Answer
|
|
Give name some fields from SQLCA.
|
View Answer
|
|
How is a typical DB2 batch pgm executed ?
|
View Answer
|
|
Will precompile of an DB2-COBOL program bomb, if DB2 is down?
|
View Answer
|
|
Is DECLARE TABLE in DCLGEN necessary? Why it used?
|
View Answer
|
|
Is it mandatory to use DCLGEN? If not, why would you use it at all?
|
View Answer
|
|
What are the contents of a DCLGEN? -
|
View Answer
|
|
What is DCLGEN ?
|
View Answer
|
|
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
|
View Answer
|
|
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
|
View Answer
|
|
Give the COBOL definition of a VARCHAR field.
|
View Answer
|
|
How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )
|
View Answer
|
|
When you COMMIT, is the cursor closed?
|
View Answer
|
|
Can you have more than one cursor open at any one time in a program ? ?
|
View Answer
|
|
Is DECLARE CURSOR executable?
|
View Answer
|