31) How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or
above only )
Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in
psuedo-conversational CICS programs.
32) Give the COBOL definition of a VARCHAR field.
A VARCHAR column REMARKS would be defined as follows:
...
10 REMARKS.
49 REMARKS-LEN PIC S9(4) USAGE COMP.
49 REMARKS-TEXT PIC X(1920).
33) What is the physical storage length of each of the following DB2 data
types:
DATE, TIME, TIMESTAMP?
DATE: 4bytes
TIME: 3bytes
TIMESTAMP: 10bytes
34) What is the COBOL picture clause of the following DB2 data types:
DATE, TIME, TIMESTAMP?
DATE: PIC X(10)
TIME : PIC X(08)
TIMESTAMP: PIC X(26)
35) What is the COBOL picture clause for a DB2 column defined as
DECIMAL(11,2)? - Ramesh
PIC S9(9)V99 COMP-3.
Note: In DECIMAL(11,2), 11 indicates the size of the data type and 2
indicates the precision.
|