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

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,


What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  


How does a cursor work?

0 Answers  


How can you quickly find out the number of rows updated after an update statement?

1 Answers   CSI, CTS,


What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,






Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  


How to view db2 table structure?

0 Answers  


Explain the use of the WHERE clause?

1 Answers  


how do you resolve -805?

3 Answers   HCL,


What is normalization and what are the five normal forms?

1 Answers  


Explain db2.

0 Answers  


What is meant by index cardinality?

2 Answers  


Categories