What is the execution result when non-SQL changes are made in a DB2 program without BIND?

In each execution of a COBOL-DB2 program, the timestamp of load module and package/DBRM are compared. If there is a change in the length of the variable (and no SQL change) in the program and it is compiled, then the load module will have the newly generated timestamp and on the other hand if the BIND is not performed then the package/DBRM would have an old timestamp. When this program is executed, the JCL step calling this program will fail with SQL error code -818.

If we have a COBOL-DB2 program for which SQL statement is never going to change in the future, we can pre-compile this program with option LEVEL.

Mandalika

Published on 11-Sep-2020 12:15:33

• Related Questions & Answers
• What is the execution result when non-SQL changes are made in the program without BIND?
• What is the execution result when a DB2 program is compiled and binded on separate days?
• What is the execution result when a DB2 program is compiled and bound on separate days?
• When a DB2 subprogram undergoes changes, do we need to BIND it with its program?
• Implementation of a table level locks in a COBOL-DB2 program during SQL execution
• What will be the result if SQLCA is not included in a COBOL-DB2 program?
• How can you revert all the DB2 table changes done in a COBOL-DB2 program?
• What are the changes we can make in our society without much effort?
• What is the jQuery event to detect when element position changes?
• How to bind multiple versions of a DB2 program into a package?
• What is the result of count function in the NULL value present in DB2 table?
• Implementation of a table level locks in a COBOL-DB2 program during program execution
• What is NON CLUSTERED INDEX in DB2? Explain with the help of practical example
• What is the order of execution of non-static blocks with respect to a constructor in Java?
• What are bind variables? How to execute a query with bind variables using JDBC?