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

SQLCODE -805 - SQL Package Not Found

What does SQLCODE -805 - SQL Package Not Found mean in RPG (IBM i / AS/400)?

The program tried to run embedded SQL but the associated *SQLPKG object created at precompile/bind time is missing from the collection it expects, usually because the program was moved to another system or library without its package, or the package was deleted.

SQLCODE -805 - SQL Package Not FoundDB2 for i · SQLRPGLE

Condition

The program tried to run embedded SQL but the associated *SQLPKG object created at precompile/bind time is missing from the collection it expects, usually because the program was moved to another system or library without its package, or the package was deleted.

Fix

Recreate the SQL package by recompiling the SQLRPGLE source (CRTSQLRPGI), or restore the missing *SQLPKG object alongside the program object whenever promoting code between environments.

Related db2 sqlcode