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 |
What r the comman abends in db2, jcl and cobol???????
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How does a cursor work?
How can you quickly find out the number of rows updated after an update statement?
What techniques will be used to avoid deadlock??
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?
How to view db2 table structure?
Explain the use of the WHERE clause?
how do you resolve -805?
What is normalization and what are the five normal forms?
Explain db2.
What is meant by index cardinality?