Data Set Options for Relational Databases

BL_RETURN_WARNINGS_AS_ERRORS= Data Set Option

Specifies whether SQL*Loader (bulk-load) warnings should surface in SAS through the SYSERR macro as warnings or as errors.

Default value:	NO
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Oracle

Syntax

BL_RETURN_WARNINGS_AS_ERRORS=YES | NO

YES: specifies that all SQLLDER warnings are returned as errors, which SYSERR reflects.
NO: specifies that all SQLLDER warnings are returned as warnings.

To specify this option, you must first set BULKLOAD=YES.