Data Set Options for Relational Databases BL_COPY_LOCATION= Data Set Option 141
Syntax
BL_CONTROL= path-and-control-filename
Syntax Description
path-and-control-filename
is an SQL*Loader file to which SQLLDR control statements are written. On most
platforms, the default file name takes the form BL_<table>_<unique-ID>.ctl, where
table is the table name
unique-ID is a number used to prevent collisions in the event of two or more
simultaneous bulk loads of a particular table. The SAS/ACCESS engine
generates the number.
Details
If you do not specify this option and a control file does not exist, a file is created in
the current directory (or with the default file specifications). If you do not specify this
option and there a control file already exists, the interface to Oracle reuses the file,
replacing the contents with the new control statements.
The SAS/ACCESS interface for Oracle creates the control file by using information
from the input data and SAS/ACCESS options. The file contains Data Definition
Language (DDL) definitions that specify the location of the data and how the data
corresponds to the database table. 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 this option, you must first specify YES for the option “BULKLOAD= Data
Set Option” on page 165.
BL_COPY_LOCATION= Data Set Option
Specifies the directory to which DB2 will save a copy of the loaded data. This option is only valid
when used in conjunction with BL_RECOVERABLE=YES
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 PC/UNIX
Default value:
none
Syntax
BL_COPY_LOCATION=pathname
