DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What is Declaration Generator ( DCLGEN )?

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

(Continued from previous question...)

What is Declaration Generator ( DCLGEN )?

DCLGEN is a facility that is used to generate SQL statements that describe a table or view. These table or view descriptions are then used to check the validity of other SQL statements at precompile time. The table or view declares are used by the DB2I utility DCLGEN to build a host language structure, which is used by the DB2 precompiler to verify that correct column names and data types have been specified in the SQL statement.

(Continued on next question...)

Other Job Interview Questions