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?

Q: What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

AN:
DATE: PIC X(10)
TIME: PIC X(08)
TIMESTAMP: PIC X(26)

(Continued on next question...)

Other Job Interview Questions

• Once you create a view, where would information about the view be stored?
• What technique is used to retrieve data from more than one table in a single SQL statement?
• What should be specified along with a cursor in order to continue updating process after commit ?
• What information is used as input to the bind process?
• What is the size of a data page ?
• Name the different types of Table spaces?
• Is there any advantage to denormalizing DB2 tables ?
• What is the error code - 803 ?
• Explain transactions, commits and rollbacks in DB2?
• What is an access path?
• More...