Is it mandatory to use DCLGEN? If not, why woul

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• What is the picture clause of the null indicator variable?
• Where are plans stored ?
• What are the functions of Bind?
• Where could you look if you had a question about whether a column has been defined as an index?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• What is dynamic SQL?
• What is the command used by TSO users to invoke DB2 ?
• What does it mean if the null indicator has -1, 0, -2??
• What is a synonym ? How is it used ?
• I use CS and update a page. Will the lock be released after I am done with that page ?
• More...