Is it mandatory to use DCLGEN? If not, why would you use it
at all?
Answer Posted / 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 View All Answers
What is a system catalog table in db2?
What is the use of reorg in db2?
Mention the definition of cobol in varchar field.
What is cursor with hold option in db2?
List some fields from sqlca?
What are the various isolation levels possible?
Explain the contents that are a part of dclgen.
What is a collection in db2?
define clustering index.
How will you return the number of records in table?
What is the maximum size of varchar data type in db2?
How do you find the maximum value in a column in db2?
How to fetch the last row from the table in SQL (db2)?
How to check sequence on a table in db2?
How to retrieve rows from a db2 table in embedded sql?