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 my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
Could anyone clearly explain the diference between sub query and correlated sub query?
What is the maximum number of columns in a db2 table?
What are the different types of base tables?
How to check last update on table in db2?
what is SPUFI ?
Explain in detail about buffer manager and its functionalities?
What are column-name qualifiers used?
What is copy book?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What is a correlated sub query?