Data Set Options for Relational Databases

BL_DATAFILE= Data Set Option [Teradata only]

Identifies the file that contains control statements.

Default value:	creates a MultiLoad script file in the current directory or with a platform-specific name
Valid in:	DATA and PROC steps (when accessing data using SAS/ACCESS software)
DBMS support:	Teradata

Syntax
Syntax Description
Details
Examples
See Also

Syntax

BL_DATAFILE=path-and-data-filename

specifies the name of the control file to generate for loading data with SAS/ACCESS Interface to Teradata using MultiLoad. On most platforms, the default filename takes the form BL_<table>_<unique-ID>.ctl:

table	specifies the table name.
unique-ID	specifies a number that is 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

To specify this option, you must first set YES for the MULTILOAD= data set option. The file contains MultiLoad Language definitions that specify the location of the data and how the data corresponds to the database table. It specifies exactly how MultiLoad should interpret the data that you are loading. Because the script file that SAS generates for MultiLoad must contain login information in clear text, it is recommended that you secure the script file by specifying a directory path that is protected.

Examples

This example generates a Teradata script file, C:\protdir\ml.ctl, on Windows.

DATA teralib.test(DBSLICEPARM=ALL BL_DATAFILE="C:\protdir\ml.ctl");
SET teralib.mydata;
run;

This next example generates a Teradata script file, fe.ctl, for FastExport and ml.ctl for MultiLoad.

data teralib.test1(MULTILOAD=YES TPT=NO BL_DATAFILE="ml.ctl");
SET teralib.test2(DBSLICEPARM=ALL BL_CONTROL="fe.ctl");
run;

BL_DATAFILE= Data Set Option [Teradata only]

Syntax

Syntax Description