What is DCLGEN?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is DCLGEN?

DCLGEN stands for declarations generator, it is a facility to generate DB2 SQL data structure in COBOL or PL/I programs.

(Continued on next question...)

Other Interview Questions

• Give some example of statistics collected during RUNSTATS?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What are the different methods of accessing DB2 from TSO?
• What is Maximum number of rows per page
• What information is contained in a SYSCOPY entry?
• Give some example of statistics collected during RUNSTATS?
• When can an insert of a new primary key value threaten referential integrity ?
• Explain the EXPLAIN statement ?
• Where besides the DB2 catalog is database object information stored by DB2?
• Which transaction use a command thread?
• More...