BL_SQLLDR_PATH= Data Set Option

Specifies the location of the SQLLDR executable file.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: SQLLDR
Restriction: This option is ignored on z/OS.
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: Oracle
See: BULKLOAD= data set option

Syntax

BL_SQLLDR_PATH=pathname

Syntax Description

pathname
specifies the full pathname to the SQLLDR executable file so that the SAS/ACCESS Interface for Oracle can call 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.