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


Please Help Members By Posting Answers For Below Questions

How to create db2 table in mainframe?

629


What is cloudant database?

641


How do you pull up a query which was previously saved in qmf?

672


What is the advantage in De-normalizing tables in DB2?

745


What is difference between alias and synonym in db2?

643






What is table space in db2?

581


What do you mean by between and in? Is between inclusive of specified range values?

668


What is deadlock in db2?

580


How and when does the db2 enforces the unique key?

615


What is explain in db2?

583


What is db2 catalog database?

582


What is db2 stogroup?

675


What is clone table?

590


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

658


Give the name of some fields form sqlca.

611