Help regarding DCLGEN effectiveness on DB2 ?

ravivv · New User Joined: 25 Jan 2006 Posts: 3 Location: Hyderabad

Can any one help regarding DCLGEN effectiveness on DB2 ?

agkshirsagar · Posted: Wed Feb 28, 2007 6:31 pm

Could you please elaborate a little more?
I didn't get your question.

agkshirsagar · Posted: Wed Feb 28, 2007 7:39 pm

DCLGEN will generate COBOL variable map for the table you want to access. The picture caluse of the variable will be decided upon the type of variable in table.
For example:
CHAR 20 in Db2 ,will be PIC X(20) in COBOL

sachin_star3 · New User Joined: 30 Sep 2006 Posts: 78 Location: pune

DCLGEN MEANS :DECLARATION GENERATOR
This is use when you go for db2-cobol prorame
The Dclgen create the host variable structure
Host variable nothing but the variable use for passing or taking the input value it alwyas represent :host variable in procedure division
dclgen is not compulsory thing you can also write the host variable manually but for exact struture generation for checking for column the dclgen is easy way

from -
sachin borase
pune

cobolunni · Posted: Mon Mar 05, 2007 10:18 pm

yes without a host program variable cobol will not be able to handle the data in the table fields of data base

mkk157 · Active User Joined: 17 May 2006 Posts: 310

For Transfter or Updating the data in DB2 tables we need Host varibles for requiresd DB2 tables. This is achieved in 2 ways.

1) Declaring manually in the Working Storage section of Data Division.
2) Using DCLGEN

In the first way It is a bit difficult to declare for big tables, By using DCLGEN we can escape from unnecessary errors.

If we use DCLGEN, In Precompilation process also It is easy to expand the cobol declaration and also to compare all the datatypes of table fields and cobol fields.