Previous Topic Next topic Print topic


SQLERROR

Indicates whether to create a package or a bind file if an error is encountered.

Syntax:

SQLERROR={NOPACKAGE | CHECK | CONTINUE}
NOSQLERROR

Parameters:

CHECK Specifies that the target system performs all syntax and semantic checks on the SQL statements being bound. A package will not be created as part of this process. If, while creating a package, an existing package with the same name and version is encountered, the existing package is neither dropped nor replaced if action replace was specified.
CONTINUE A package or a bind file is created even when SQL errors are encountered. This option is not supported by DB2.
NOPACKAGE A package or a bind file is not created if an error is encountered.

Properties:

Default: NOSQLERROR
Synonym: ERROR.

Comments:

If syntax is used together with the package option, package is ignored.

Previous Topic Next topic Print topic