PL/I · DB2 SQLCODE

SQLCODE +204: Undefined Name

What does SQLCODE +204: Undefined Name mean in PL/I?

A statement in the PL/I program references a table, view, or other object name that doesn't exist in the DB2 subsystem at bind or execute time. This commonly happens when a DCLGEN was generated against a table that was later dropped or renamed, or CURRENT SQLID doesn't resolve to the qualifier the program expects.

SQLCODE +204: Undefined NameDB2 for z/OS · PL/I (embedded SQL)

Condition

A statement in the PL/I program references a table, view, or other object name that doesn't exist in the DB2 subsystem at bind or execute time. This commonly happens when a DCLGEN was generated against a table that was later dropped or renamed, or CURRENT SQLID doesn't resolve to the qualifier the program expects.

Fix

Confirm the object exists under the schema the plan or package actually resolves to, regenerate the DCLGEN if the table definition changed, and rebind after correcting the statement so it stops paying the dynamic-bind penalty on every execution.

Related db2 sqlcode