Interview Questions

Is it mandatory to use DCLGEN? If not, why would you use it at all ?

DB2 ( IBM Database 2 ) Interview Questions


(Continued from previous question...)

Is it mandatory to use DCLGEN? If not, why would you use it at all ?

It is not mandatory to use DCLGEN. Using DCLGEN, helps detect wrongly spelt column names etc. during the pre-compile stage itself ( because of the DECLARE TABLE ). DCLGEN being a tool, would generate accurate host variable definitions for the table reducing chances of error.

(Continued on next question...)

Other Interview Questions