|
Question |
Rating |
View Answer |
|
How would you retrieve rows from a DB2 table in embedded SQL? ? |
|
View Answer |
|
Where would you specify the DECLARE CURSOR statement? ? |
|
View Answer |
|
How do you specify and use a cursor in a COBOL program? ? |
|
View Answer |
|
What happens when you say OPEN CURSOR? |
|
View Answer |
|
Is DECLARE CURSOR executable? |
|
View Answer |
|
Can you have more than one cursor open at any one time in a program ? ? |
|
View Answer |
|
When you COMMIT, is the cursor closed? |
|
View Answer |
|
How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only ) |
|
View Answer |
|
Give the COBOL definition of a VARCHAR field. |
|
View Answer |
|
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP? |
|
View Answer |
|
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)? |
|
View Answer |
|
What is DCLGEN ? |
|
View Answer |
|
What are the contents of a DCLGEN? - |
|
View Answer |
|
Is it mandatory to use DCLGEN? If not, why would you use it at all? |
|
View Answer |
|
Is DECLARE TABLE in DCLGEN necessary? Why it used? |
|
View Answer |
|
Will precompile of an DB2-COBOL program bomb, if DB2 is down? |
|
View Answer |
|
How is a typical DB2 batch pgm executed ? |
|
View Answer |
|
Give name some fields from SQLCA. |
|
View Answer |
|
What is EXPLAIN? ? |
|
View Answer |
|
What do you need to do before you do EXPLAIN? |
|
View Answer |