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 declare 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 SQL statement.

Popularity: unranked [?]

Related interview questions

• DB2 understanding : Part – II
• What is a Database Request Module (DBRM)?
• What is a host variable?
• What is a foreign key?
• What is meant by an index?