Is it mandatory to use DCLGEN? If not, why would you use it
at all?
Answers were Sorted based on User's Feedback
Answer / abhisek
No,it is not mandatory to use DCLGEN,it is used by the pre-
compiler to validate the table names,view names and column
names during pre-compile.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / guest
Just an addition to the above answer. By using the DCLGEN,
the program would use correct data types and column lengths
which avoids stage 2 processing of predicates, if the data
types and lengths mismatched.
Is This Answer Correct ? | 2 Yes | 0 No |
In which column of which DB2 catalog would you find the length of the rows for all tables?
What does DML stand for and what are some examples of it?
What is referential integrity?
Describe major components of db2?
What is dclgen (declaration generator)?
can any body explain about plan and pakage in detail....
What is a db2 tablespace?
Explain the function done by data manager?
wht is d/f between union and joins ?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is query for your birthday date should be in hours,minute and seconds format?