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.