164 BL_WARNING_COUNT= Data Set Option Chapter 10
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
Oracle
Default value:
SQLLDR
Syntax
BL_SQLLDR_PATH=pathname
Syntax Description
pathname
is the full pathname to the SQLLDR executable file so that the SAS/ACCESS
interface for Oracle can invoke SQL*Loader.
Details
Normally there is no need to specify this option because the environment is set up to
find the Oracle SQL*Loader automatically.
Operating Environment Information: This option is ignored on OS/390.
To specify this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165.
BL_WARNING_COUNT= Data Set Option
Specifies the maximum number of row warnings to allow before aborting the load operation
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 UNIX/PC
Default value:
2147483646
Syntax
BL_WARNING_COUNT=warning-count
Details
Use this option to limit the maximum number of rows that generate warnings.
Consult the log file for information about why the rows generated warnings.
To specify this option, you must first specify a value for “BL_REMOTE_FILE= Data
Set Option” on page 162 and specify YES for the option “BULKLOAD= Data Set
Option” on page 165.
