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?
- 2 Answers
- 16553 Views
- I also Faced
- E-Mail Answers
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 are the two types of logging in the db2 database? Explain them.
What is a collection in db2?
What does reorg do in db2?
What is cursor with hold option in db2?
Is db2 relational database?
Explain the function of data manager.
What is the use of db2 optimizer?
What is multi row fetch in db2?
How do I add a column in db2?
What is database alias db2?
What is ibm db2 client?
Can there be more than one cursor open for any program?
Which components manage deadlocks in db2?
What is the clustering index in the db2 database?
What is schema in db2?
