What is the execution result when a DB2 program is compiled and bound on separate days?

The program will run successfully (unless there are no logical errors in the program)because the timestamp is inserted in the DBRM during pre-compilation and pre-compilation is done before the compilation step. Therefore, the DBRM and the load module will have the same timestamp.

The timestamp inserted in the DBRM is further passed to the package also. So in case, if we are using DBRM-package-plan combination, In that case also the program will run successfully as there is the consistency in the timestamp throughout.

Mandalika

Published on 11-Sep-2020 12:12:19

• Related Questions & Answers
• What is the execution result when a DB2 program is compiled and binded on separate days?
• What is the execution result when non-SQL changes are made in a DB2 program without BIND?
• What is the execution result when non-SQL changes are made in the program without BIND?
• What will be the result if SQLCA is not included in a COBOL-DB2 program?
• What is the result of count function in the NULL value present in DB2 table?
• Is PHP compiled or interpreted?
• Why java is both compiled and interpreted language.
• What is the purpose and usage of SQLCODE within the SQLCA in a COBOL-DB2 program
• What is the use and syntax of SEQUENCE in DB2?
• Perl is Interpreted or Compiled Language?
• What is execution engine in JAVA?
• What is the usage and purpose of DCLGEN and host variables used in COBOL-DB2 program
• What is the definition and usage of alternate key in a DB2 table?
• What is training? When and why it is needed?
• What is NULL check and insertion rule in a DB2 table?