we can code COPY DCLGEN or INCLUDE DCLGEN,
At which stage of the precompilation , dclgen get expanded
if we write 1) copy
2) include
one question about dclgen..
Is it mandatory to use declare table in dclgen..
I think no...but
it will be used by the precompiler to validate the table
name,column name etc..,
can one clear my doubt ..is it necessary to include
declare table or not?
Answer Posted / rama krishna reddy
During the precompilation time only copybooks mentioned
with INCLUDE are expanded all copy books mentioned with
COPY are expanded during compilation time
we have to specify all the dclgens and host variable
declartions using INCLUDE statement because those are
required during precompilation period.
Declare statement is not mandatory in the DCLGEN.it can be
used to validate the sql statements in the program i.e it
checks the table name and columns names and it gives the
corresponding warning messages.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is db2 bind?
What is reorg?
What is the latest version of ibm db2?
What is isolation level in db2?
Explain about mirror activator disk mirroring?
What is difference between isnull and coalesce?
What is the information associated with sysibm.syslinks table?
What is release/acquire in bind?
What are types of indexes?
Can there be more than one cursor open for any program?
How to find primary key of a table in db2?
Explain package in db2 and its advantages?
What is the role of data manager in the db2 database?
What types of tables are there in the db2 database?
When the like statement is used?