USING DCLGEN as INPUT LAYOUT but will not call db2 table

grem · Posted: Thu Jul 21, 2011 1:09 pm

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!

enrico-sorichetti · Posted: Thu Jul 21, 2011 1:16 pm

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

dbzTHEdinosauer · Posted: Thu Jul 21, 2011 2:03 pm

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: