PL/I · DB2 SQLCODE

SQLCODE -805: Package Not Found in Plan

What does SQLCODE -805: Package Not Found in Plan mean in PL/I?

The PL/I program's plan doesn't have a bound package matching the DBRM, collection, and consistency token the currently executing load module expects — usually because the program was recompiled and rebound into a package, but the package was never added to the plan's package list, or CURRENT PACKAGESET is set wrong.

SQLCODE -805: Package Not Found in PlanDB2 for z/OS · PL/I (embedded SQL)

Condition

The PL/I program's plan doesn't have a bound package matching the DBRM, collection, and consistency token the currently executing load module expects — usually because the program was recompiled and rebound into a package, but the package was never added to the plan's package list, or CURRENT PACKAGESET is set wrong.

Fix

Bind the package into the plan's PKLIST and rebind the plan, and confirm CURRENT PACKAGESET or CURRENT PACKAGE PATH in the program matches the collection the package was actually bound into.

Related db2 sqlcode