Tags

, , , , , , , ,

Usually when multiple projects are going on simultaneously and different changes are made to the same table, both the project teams need to coordinate and then test.

In this scenario, one project has added a new column into the table in test region and other project tried to compile/bind a program where it had inserts into the modified table. As the Insert did not have the new column added in the list, the bind failed with SQLCODE -117. Now the Insert statement needs to be corrected by adding the new column and the program needs to be bind which will solve the issue.

Below details are from the IBM site for the SQLCODE

Explanation
The number of insert values in the value list of the insert operation is not the same as the number of object columns specified. Alternatively, the number of values on the right side of an assignment in a SET assignment statement or the SET clause of an update operation does not match the number of columns on the left side.

System action
The statement cannot be processed. No data was inserted into the object table.

Programmer response
Correct the statement to specify one and only one value for each of the specified object columns.

SQLSTATE
42802

https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/codes/src/tpc/n117.html

——————————————————————————————————–

If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog

——————————————————————————————————–

You may also like to look at:

Working on Mainframes – Is Change to a different technology necessary
Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
HOW TO SUBMIT A BATCH JOB FROM THE CICS PROGRAM
CICS – EXEC interface block – EIBRESP Values
CICS – EXEC interface block Fields
Flow of control between COBOL programs, run units, and CICS
CICS INTERVIEW QUESTIONS
CICS TIPS
COBOL – COPY and INCLUDE statements
COBOL – PERFORMANCE IMPROVEMENT
COBOL – SIGN STORED IN COMP, COMP-3 AND DISPLAY FORMATS
SHORTEST COBOL PROGRAM
RESTART LOGIC IN COBOL DB2 Program
GOBACK – EXIT PROGRAM – STOP RUN
Continuation lines in COBOL
Computational items – COMP, COMP 1 , COMP 2, COMP 3
COBOL program format
cobol indicator area column-7 and area a and area b
COBOL INTERVIEW QUESTIONS
COBOL TIPS
COBOL COMPILER OPTIONS
The IDENTIFICATION DIVISION