What is DCLGEN in DB2?

1.	What is DCLGEN in DB2?
Answer» DCLGEN stands for Declarations GENERATOR. The PROGRAMS that we write should declare the tables and views that it accesses. The declarations generator i.e. DCLGEN produces these DECLARE statements for C, Cobol and PL/I programs so that one does not need to code the statements manually. It also generates corresponding HOST variable structures. When DCLGEN is USED to generate a table declaration, the DB2 uses the DB2 catalog to get the relevant information from it. DCLGEN, then uses this information to create an SQL DECLARE TABLE statement for the table/view.

Discussion