DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

Is DECLARE TABLE in DCLGEN necessary? Why it us

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Is DECLARE TABLE in DCLGEN necessary? Why it used?

It not necessary to have DECLARE TABLE statement in DCLGEN. This is used by the pre-compiler to validate the table-name, view-name, column name etc.., during pre-compile.

(Continued on next question...)

Other Job Interview Questions