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

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

• How would you retrieve rows from a DB2 table in embedded SQL? –
• What are the 2 sqlcodes that are returned? –
• How to read last record in vsam file.,I don't know how many records are there?
• What is the difference between CS and RR isolation levels?
• What is UNION,UNION ALL? –
• How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)
• Where do you specify them ?
• What are correlated subqueries?
• Will precompile of an DB2-COBOL program bomb, if DB2 is down?
• How do you eliminate duplicate values in DB2 SELECT ?
• More...