Will precompile of an DB2-COBOL program bomb, if

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

(Continued from previous question...)

Will precompile of an DB2-COBOL program bomb, if DB2 is down?

No. Because the precompiler does not refer to the DB2 catalogue tables.

(Continued on next question...)

Other Job Interview Questions

• How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ?
• How do you find the maximum value in a column in DB2?
• What is COPY PENDING status?
• Is DECLARE TABLE in DCLGEN necessary? Why it used?
• What is the difference between SYNONYM and ALIAS?
• What is a DB2 plan?
• Explain difference between sys.cat and sys.ibm?
• What is the result of this query if no rows are selected:
• How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only )
• Where do you specify them ?
• More...