Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17921 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
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is a buffer in memory?
What are bind parameters in db2?
what are bind concepts in db2 cobol?
Explain about rct in db2?
Name the lockable units in DB2?
What is role in db2?
What is buffer pool?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How do you eliminate duplicate values in db2?
How to compare data between two tables in db2?
What is access path in db2?
What are types of indexes?
How do I import data from excel to db2?
Explain how can you do the explain of a dynamic sql statement?
