SQLERROR bind option

The SQLERROR option determines whether to create a package if SQL errors occur.

Command option	Option values	Used with
SQLERROR	(NOPACKAGE) (CONTINUE) (CHECK)	BIND PACKAGE BIND SERVICE subcommand (DSN) ¹

Note:

SQLERROR(NOPACKAGE): Creates no package if an error occurs.
SQLERROR(CONTINUE): Creates a package, even if errors occur when binding SQL statements. The statements in error cannot execute. Any attempt to execute them at run time causes errors.
SQLERROR(CHECK): Performs all syntax and semantic checks on the SQL statements being bound when the authorization ID for BIND does not have the privilege to execute the statements. A package is not created as part of this process. If an existing package with the same name and version is encountered during bind processing, the existing package is not dropped or replaced, even if ACTION(REPLACE) was specified.

Default values for SQLERROR

Process	Default value
BIND PLAN	N/A
BIND PACKAGE	NOPACKAGE
BIND SERVICE	NOPACKAGE
REBIND PLAN	N/A
REBIND PACKAGE	N/A. Because you cannot use the option SQLERROR for REBIND PACKAGE, the value for the previous package remains in effect when you rebind that package. If you rebind a package that uses SQLERROR(CONTINUE), SQL statements that were in error at BIND time are not rebound.

See the SQLERROR column in SYSPACKAGE catalog table.