Data Set Options for Relational Databases

BL_SQLLDR_PATH= Data Set Option

Specifies the location of the SQLLDR executable file.

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

Syntax

BL_SQLLDR_PATH=pathname

pathname: is the full pathname to the SQLLDR executable file so that the SAS/ACCESS Interface for Oracle can invoke SQL*Loader.

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

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 z/OS. [cautionend]