

SQL Codes › SQL Return Codes -1 through -999 › -120 - PROGRAM TIMESTAMP timestamp-in-decimal NOT = PLAN TIMESTAMP timestamp-in-decimal
-120 - PROGRAM TIMESTAMP timestamp-in-decimal NOT = PLAN TIMESTAMP timestamp-in-decimal
Reason:
The program does not match the SQL plan (indicated by the different timestamps displayed in the text). This can occur in the following ways:
- Executing a version of the program from an old load library after changing and compiling a newer version of the program.
- Preprocessing a new program with the same plan name and AUTHID as an existing program and then executing the preexisting program.
- Executing a changed CICS program without issuing a CICS "new-copy" command.
- Transporting the plan to another Multi-User Facility without moving the load module or moving the load module without transporting the plan.
The SQLSTATE that equates to this SQL return code is 51003.
Action:
Preprocess the program again or remedy any applicable condition listed above.
Copyright © 2014 CA.
All rights reserved.
 
|
|