RPG (IBM i / AS/400) · DB2 SQLCODE
What does SQLCODE -818 - Consistency Tokens Do Not Match mean in RPG (IBM i / AS/400)?
The program object's embedded consistency token doesn't match the token stored in its SQL package, which happens when the *PGM and its *SQLPKG get out of sync - typically one was recompiled, restored, or promoted without the other.
The program object's embedded consistency token doesn't match the token stored in its SQL package, which happens when the *PGM and its *SQLPKG get out of sync - typically one was recompiled, restored, or promoted without the other.
Recompile the SQLRPGLE program so the program and its package regenerate together, and make sure deployment scripts always move the program and its SQL package as a matched pair.