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
Explain db2.
Define buffer pool.
What is explain plan in db2?
What does db2 mean?
Is ibm db2 free?
What is bind package and plan in db2?
What are iseries servers?
What is innodb buffer pool?
Name the lockable units in DB2?
What is the difference between plan and package in db2?
When the like statement is used?
What is dbrm in db2 database?
What is the result of open cursor statement?
Which are the db2 tools to protect integrity of the database?
How to create backup table in db2?