RPG (IBM i / AS/400) · DB2 SQLCODE

SQLCODE -204 - Object Not Defined

What does SQLCODE -204 - Object Not Defined mean in RPG (IBM i / AS/400)?

An embedded SQL statement referenced a table, view, index, or other object that doesn't exist under the schema the job is currently using, commonly because the library list doesn't include the target library or the object name was mistyped.

SQLCODE -204 - Object Not DefinedDB2 for i · SQLRPGLE

Condition

An embedded SQL statement referenced a table, view, index, or other object that doesn't exist under the schema the job is currently using, commonly because the library list doesn't include the target library or the object name was mistyped.

Fix

Qualify the object name with its library/schema in the SQL statement, or fix the job's library list/SQL naming mode, and confirm the object was actually created or promoted in this environment.

Related db2 sqlcode