|
Question |
Rating |
View Answer |
|
49) 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 |
|
48) How do you do the EXPLAIN of a dynamic SQL statement? |
|
View Answer |
|
47) EXPLAIN has output with MATCHCOLS = 0. What does it mean? � |
|
View Answer |
|
47) EXPLAIN has output with MATCHCOLS = 0. What does it mean? � |
|
View Answer |
|
45) What do you need to do before you do EXPLAIN? |
|
View Answer |
|
44) What is EXPLAIN? � drona questions |
|
View Answer |
|
43) How can you quickly find out the # of rows updated after an update statement? |
|
View Answer |
|
42) Name some fields from SQLCA. |
|
View Answer |
|
41) How is a typical DB2 batch pgm executed ? |
|
View Answer |
|
40) Will precompile of an DB2-COBOL program bomb, if DB2 is down? |
|
View Answer |
|
39) Is DECLARE TABLE in DCLGEN necessary? Why it used? |
|
View Answer |
|
38) Is it mandatory to use DCLGEN? If not, why would you use it at all? - |
|
View Answer |
|
37) What are the contents of a DCLGEN? - |
|
View Answer |
|
37) What are the contents of a DCLGEN? - |
|
View Answer |
|
36) What is DCLGEN ? - |
|
View Answer |
|
35) What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)? - Ramesh |
|
View Answer |
|
34) What is the COBOL picture clause of the following DB2 data types: |
|
View Answer |
|
33) What is the physical storage length of each of the following DB2 data types: |
|
View Answer |
|
32) Give the COBOL definition of a VARCHAR field. |
|
View Answer |
|
31) How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only ) |
|
View Answer |