What is the COBOL picture clause of the followin

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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)

(Continued on next question...)

Other Job Interview Questions

• Are views updateable ?
• What is the physical storage length of each of the following DB2 data types:
• Is DECLARE CURSOR executable?
• What is a collection?
• What is index cardinality? –
• What are the contents of a DCLGEN?
• What is DCLGEN ?
• What is the picture clause of the null indicator variable? –
• What is dynamic SQL? ––
• What is FREEPAGE and PCTFREE in TABLESPACE creation?
• More...