What is the COBOL picture clause for a DB2 colum

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

(Continued from previous question...)

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

PIC S9(9)V99 COMP-3.
Note: In DECIMAL(11,2), 11 indicates the size of the data type and 2 indicates the precision.

(Continued on next question...)

Other Job Interview Questions

• How do you retrieve the data from a nullable column? –
• My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?
• Why SELECT * is not preferred in embedded SQL programs?
• How to read last record in vsam file.,I don't know how many records are there?
• Is DECLARE TABLE in DCLGEN necessary? Why it used?
• EXPLAIN has output with MATCHCOLS = 0. What does it mean? –
• What is a NULL value? What are the pros and cons of using NULLS?
• Is there any advantage to denormalizing DB2 tables?
• What is IMAGECOPY ? –
• What is a synonym ?
• More...