IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

USING DCLGEN as INPUT LAYOUT but will not call db2 table


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10803
Location: italy

PostPosted: Thu Jul 21, 2011 1:16 pm
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: 6967
Location: porcelain throne

PostPosted: Thu Jul 21, 2011 2:03 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts REXX table content on panel will be r... CLIST & REXX 6
No new posts File Status Error code 39 when Proces... COBOL Programming 2
No new posts create table with more than 32k recor... DB2 1
No new posts Issued a CMD call for /DIS & it r... IMS DB/DC 3
This topic is locked: you cannot edit posts or make replies. COBOL-Common routine that contains al... COBOL Programming 4
Search our Forums:

Back to Top