What is DCLGEN?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is DCLGEN?

DeClarations GENerator: used to create the host language copy books for the table definitions. Also creates the DECLARE table.

(Continued on next question...)

Other Interview Questions

• What is the meaning of -805 SQL return code ?
• What is the error code for Unique Index Violation?
• How does the processing of a correlated subquery differ from a non correlated subquery ?
• When would you prefer to use VARCHAR ?
• What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ?
• What is the name of the default DB2 catalog database ?
• When would you prefer to use VARCHAR ?
• What is the difference between SYNONYM and ALLAS?
• What is a result table ?
• What is ACQUIRE/RELEASE in BIND?
• More...