Hi all,

A very good morning to the members. I am very new to DB2 and wanted to know how DCLGEN is used in COBOL-DB2 program.
If anyone can explain with a reference program, kindly help.

Thanks,
Niraj

The DCLGEN will produce the working storage variables for a table or a view that you can copy into your program. In COBOL, the host variables need to included in the Working Storage Section.

Hi Marcus,

Thanks for your reply.
Still my question is how it is done.
I mean, is DCLGEN a utility that creates host variables?

Waiting for your reply,
Nitesh

Hi Marcus,

Thanks for your reply.
Still my question is how it is done.
I mean, is DCLGEN a utility that creates host variables?

Waiting for your reply,
Nitesh

DCLGEN is a DB2-Command that can be executed in foreground ( e.g. invoked by the TSO/DB2-Interactive Panel ) or in background.

It generates a copy-book that containes the declaration of the table
( EXEC SQL DECLARE TABLE .... ) and that includes also the definitions of
the host variables.
Those definitiones can be generated for the COBOL, PL/I or C -language.

Logon on to TSO and go to the DB2 panel, and select DB2I.

The Decalre Table is actually optional, and is only used by the DB2 precompiler to validate SQL statements that would otherwise not be validated until the bind step. But there is no reason to not use it.