PL/I · DB2 SQLCODE

SQLCODE -818: Precompiler Timestamp Does Not Match the Bind Timestamp

What does SQLCODE -818: Precompiler Timestamp Does Not Match the Bind Timestamp mean in PL/I?

The consistency timestamp embedded in the PL/I load module during precompilation doesn't match the timestamp DB2 has for the bound DBRM or package — a classic case of compiling and link-editing a program after a source change but binding an older DBRM, or the reverse.

SQLCODE -818: Precompiler Timestamp Does Not Match the Bind TimestampDB2 for z/OS · PL/I (embedded SQL)

Condition

The consistency timestamp embedded in the PL/I load module during precompilation doesn't match the timestamp DB2 has for the bound DBRM or package — a classic case of compiling and link-editing a program after a source change but binding an older DBRM, or the reverse.

Fix

Redo the full precompile-compile-link-bind sequence from the current source so the load module, DBRM, package, and plan are all consistent, rather than mixing a fresh package bind with an old load module or vice versa.

Related db2 sqlcode