Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Help regarding DCLGEN effectiveness on DB2 ?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
ravivv

New User


Joined: 25 Jan 2006
Posts: 3
Location: Hyderabad

PostPosted: Wed Feb 28, 2007 5:39 pm    Post subject: Help regarding DCLGEN effectiveness on DB2 ?
Reply with quote

Can any one help regarding DCLGEN effectiveness on DB2 ?
Back to top
View user's profile Send private message

agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Wed Feb 28, 2007 6:31 pm    Post subject: Could you please elaborate a little more?
Reply with quote

Could you please elaborate a little more?
I didn't get your question. icon_question.gif
Back to top
View user's profile Send private message
agkshirsagar

Active Member


Joined: 27 Feb 2007
Posts: 686
Location: Earth

PostPosted: Wed Feb 28, 2007 7:39 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
sachin_star3
Warnings : 1

New User


Joined: 30 Sep 2006
Posts: 78
Location: pune

PostPosted: Sun Mar 04, 2007 5:28 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
cobolunni

Active User


Joined: 07 Aug 2006
Posts: 128
Location: kerala,india

PostPosted: Mon Mar 05, 2007 10:18 pm    Post subject:
Reply with quote

yes without a host program variable cobol will not be able to handle the data in the table fields of data base
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Wed Mar 07, 2007 2:32 pm    Post subject: Re: Help regarding DCLGEN effectiveness on DB2 ?
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Unable to view Unloaded file using DC... Rohit Umarjikar DB2 4 Thu Dec 31, 2015 6:46 pm
No new posts Expand COBOL copybooks and DCLGEN Mike 1304 COBOL Programming 17 Sun May 26, 2013 10:54 pm
No new posts DCLGEN change prino DB2 1 Tue Dec 25, 2012 1:13 am
No new posts USING DCLGEN as INPUT LAYOUT but will... grem Mainframe Interview Questions 2 Thu Jul 21, 2011 1:09 pm
No new posts Generating Multiple DCLGEN's enrico-sorichetti DB2 4 Mon Apr 04, 2011 8:39 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us