What is the equivalent COBOL DATA Type for Decim

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

(Continued from previous question...)

What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ?

Q; What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ? what does the current SQLID register contain ?

An:
PIC S9(x-y) V9(Y) COMP-3. the current SQLID contain the current authorization ID.

(Continued on next question...)

Other Job Interview Questions

• What is the maximum number of tables that can be stored on a Partitioned Tables Space?
• How do you simulat the EXPLAIN of an embedded SQL statement in SPUFI/QMF ?
• What are some SQL aggregates and other built-in functions?
• What information is used as input to the bind process?
• What is a clustering index?
• I use CS and update a page. Will the lock be released after I am done with that page ?
• What is EXPLAIN?
• What is lock contention?
• How is a typical DB2 batch program executed?
• What will the COMMIT accomplish?
• More...