What is DCLGEN?

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

(Continued from previous question...)

What is DCLGEN?

DeClarations GENerator: used to create the host language copy books for the table definitions. Also creates the DECLARE table.

(Continued on next question...)

Other Job Interview Questions

• What is COPY PENDING status ?
• What is a SELECT statement ?
• Explain an outer join ?
• In a DB2-CICS program which is acts as co-ordinator and which is participant?
• What technique is used to retrieve data from more than one table in a single SQL statement?
• What is JOIN and different types of JOIN ?
• What is a correlated sub query?
• What are the three DB2 date and time data types and their associated functions?
• What is a synonym ? How is it used ?
• What is auditing
• More...