BL_CONTROL=

BL_CONTROL=

Determines the name and location of a file containing SQLLDR control statements.

Default value: creates a control file in the current directory.

Syntax

Syntax

BL_CONTROL=path-and-control-filename

path-and-control-filename: An SQL*Loader file to which SQLLDR control statements are written. You can specify the full path and filename in this argument, or use the default file name and location. The default action is to create a bl_<tablename>.ctl file in the current directory.

Details

The SAS/ACCESS engine for ORACLE creates the control file using information from the input data and SAS/ACCESS options. The file contains Data Definition Language (DDL) definitions. It is used to specify exactly how the loader should interpret the data that you are loading from the data file ( .dat file).

To specify BL_CONTROL, you must first specify YES for the option BULKLOAD=.

Chapter Contents
Previous
Next
Top of Page