Can we declare DB2 HOST variable in COBOL COPY b

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

(Continued from previous question...)

Can we declare DB2 HOST variable in COBOL COPY book ?

NO. If we declare DB2 host variable in COBOL COPY book, at the time of Pre-compilation we get the host variable not defined, because pre-compiler will not expand COBOL COPY book. So we declare it either in DCLGEN with EXEC SQL INCLUDE DCLGEN name END-EXEC or we directly hardcode it in the working storage section.

(Continued on next question...)

Other Job Interview Questions

• How many clustering indexes can be defined for a table?
• Are view updatable?
• Will precompile of an DB2 - COBOL program bomb, if DB2 is down?
• What do you need to do before you do EXPLAIN?
• Once you create a view, where would information about the view be stored?
• What is a synonym ? How is it used ?
• What is SQLcode - 811?
• What is a synonym ? How is it used ?
• What is the picture clause of the null indicator variable?
• Where is the output of EXPLAN stored?
• More...