Data Set Options for Relational Databases

BL_WARNING_COUNT= Data Set Option

Specifies the maximum number of row warnings to allow before the load fails.

Default value:	2147483646
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	DB2 under UNIX and PC Hosts

Syntax

BL_WARNING_COUNT=warning-count

warning-count: specifies the maximum number of row warnings to allow before the load fails.

To specify this option, you must first set BULKLOAD=YES and also specify a value for BL_REMOTE_FILE=.

Use this option to limit the maximum number of rows that generate warnings. See the log file for information about why the rows generated warnings.