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? Explain.
What is buffer pool and list some of them?
What is explain plan in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
List out the data types available.
What does runstats do in db2?
What is the latest version of ibm db2?
What do you mean by between and in? Is between inclusive of specified range values?
How many types of page locks can be held in db2?
What is dbrm? When it will be created?
What are the full forms of spufi and dclgen and why are they used?
How does coalesce work?
Is it possible using max on a char column?
What are the uses of db2 optimizer?
what is the responsibility of the construction superintendent