Is it mandatory to use DCLGEN? If not, why would you use it
at all?

Answers were Sorted based on User's Feedback



Is it mandatory to use DCLGEN? If not, why would you use it at all?..

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

Is it mandatory to use DCLGEN? If not, why would you use it at all?..

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

Post New Answer

More DB2 Interview Questions

In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  


What does DML stand for and what are some examples of it?

3 Answers   IBM,


What is referential integrity?

5 Answers  


Describe major components of db2?

0 Answers  


What is dclgen (declaration generator)?

0 Answers  






can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,


What is a db2 tablespace?

0 Answers  


Explain the function done by data manager?

0 Answers  


wht is d/f between union and joins ?

2 Answers  


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

2 Answers  


in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,


What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,


Categories