Data Set Options for Relational Databases |
Specifies a prefix for the
names of the temporary tables that
MultiLoad uses during a bulk-load operation.
Default value: |
none
|
Valid in: |
DATA and PROC steps (when creating and appending
to DBMS tables using SAS/ACCESS software)
|
DBMS support: |
Teradata
|
ML_LOG=prefix-for-MultiLoad-temporary-tables
|
- prefix-for-MultiLoad-temporary-tables
-
specifies the prefix to use when naming Teradata tables
that the Teradata MultiLoad utility uses during a bulk-load operation.
To specify this option, you must first set MULTILOAD=YES.
You can use this option to specify a prefix for the temporary table
names that the MultiLoad utility uses during the load process. The MultiLoad
utility uses a log table, two error tables, and a work table while loading
data to the target table. By default, here are the names for these tables,
where randnum is a random number.
Temporary Table |
Table Name |
Restart table |
SAS_ML_RS_randnum |
Acquisition error table |
SAS_ML_ET_randnum |
Application error table |
SAS_ML_UT_randnum |
Work table |
SAS_ML_WT_randnum |
To override the default names, here are
the table names that would be
generated if ML_LOG=MY_LOAD
,
for example.
Temporary Table |
Table Name |
Restart table |
MY_LOAD_RS |
Acquisition error table |
MY_LOAD_ET |
Application error table |
MY_LOAD_UT |
Work table |
MY_LOAD_WT |
SAS/ACCESS automatically deletes
the error tables if no errors are logged. If there are errors, the tables
are retained, and SAS/ACCESS issues
a warning message that includes the names of the tables in error.
Note: Do not use ML_LOG= with ML_RESTART=, ML_ERROR1=, ML_ERROR2=, or
ML_WORK= because ML_LOG= provide specific names to the temporary files. ![[cautionend]](../../../../common/63294/HTML/default/images/cautend.gif)
For more information about temporary table names that the Teradata MultiLoad
utility uses and what is stored in each, see the Teradata MultiLoad
reference.
ML_ERROR1= Data Set Option
ML_ERROR2= Data Set Option
ML_RESTART= Data Set Option
ML_RESTART= Data Set Option
ML_WORK= Data Set Option
MULTILOAD= Data Set Option
Using MultiLoad
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.