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
• How can you revert all the DB2 table changes done in a COBOL-DB2 program?
• What will be the result if SQLCA is not included in a COBOL-DB2 program?
• How to bind multiple versions of a DB2 program into a package?
• What is the jQuery event to detect when element position changes?
• What are the changes we can make in our society without much effort?
• Implementation of a table level locks in a COBOL-DB2 program during program execution
• What happens to a PCB when the state of a process changes?
• What is the result of count function in the NULL value present in DB2 table?
• What is NON CLUSTERED INDEX in DB2? Explain with the help of practical example
• Write the DB2 SQL query to find the third highest ORDER_TOTAL in a ORDERS DB2 table