SQLWARN

Indicates whether warnings will be returned from the compilation of dynamic SQL statements (via PREPARE or EXECUTE IMMEDIATE), or from describe processing (via PREPARE...INTO or DESCRIBE). This DB2 precompile/bind option is not supported by DRDA.

Syntax:

SQLWARN={YES | NO}
NOSQLWARN

Parameters:

NO Warnings will not be returned from the SQL compiler.
YES Warnings will be returned from the SQL compiler.

Properties:

Default: NOSQLWARN
Synonym: WARN.

Comments:

SQLCODE +238 is an exception. It is returned regardless of the sqlwarn option value.