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 are the benefits of using the db2 database?
Name the various locking levels available?
On which levels locks can be applied?
What is the difference between TYPE 1 index & TYPE 2 index
What's the difference between DB2 active log and archive log? Thanks a lot...
Where could you look if you had a question about whether a column has been defined as an index?
What is the use of predicate?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
Describe major components of db2?
Is ibm db2 free?
Explain the function of data manager.
How many databases are there?