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
 

 

USING DCLGEN as INPUT LAYOUT but will not call db2 table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
grem

New User


Joined: 06 May 2009
Posts: 14
Location: philippines

PostPosted: Thu Jul 21, 2011 1:09 pm    Post subject: USING DCLGEN as INPUT LAYOUT but will not call db2 table
Reply with quote

Hi,

The requirement of my component is that my INPUT 1 will use a DCLGEN of table AADT003
but my component will not use the DB2 table it will just use the DCL for its input layout.

for example the DCLGEN of that table is AAGT003.

should i code
EXEC SQL
INCLUDE AAGT003
END-EXEC

or just a

COPY AAGT003

please help.
thanks!
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Thu Jul 21, 2011 1:16 pm    Post subject: Reply to: USING DCLGEN as INPUT LAYOUT but will not call db2
Reply with quote

in general it will depend on Your source library setup and standards but You/Your support should consider ...

if the program ( any language ) is accessing DB2 tables it will make little/no difference
( the program has to go thru the db2/builtin preprocessor stage )

if the program <is not> a db2 program using the EXEC SQL INCLUDE directive
will put a useless dependence on SQL preprocessing
and it will cause a bit of useless processing and library accesses
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jul 21, 2011 2:03 pm    Post subject:
Reply with quote

but keep in mind,

if this is not a db2 program, thus not using any db2 pre-processing,
and you use the copy cobol compiler directive,
the sql ddl statement declaring the table
will cause compiler errors.

and this is just bullshit:
Quote:
The requirement of my component is that my INPUT 1 will use a DCLGEN of table AADT003
but my component will not use the DB2 table it will just use the DCL for its input layout.


a dclgen contains both the sql ddl statements and the cobol field declarations.

your requirement is to have a structure equivalent to the cobol field declarations for a row.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 1 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Formating the Input file sreekusr DFSORT/ICETOOL 3 Fri Feb 17, 2017 10:40 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts Submit job from Cobol with input data abdulrafi COBOL Programming 4 Wed Feb 01, 2017 12:41 pm


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