Specifies a prefix for the names of the temporary tables that non-TPT MultiLoad uses during a bulk-loading operation.
| Valid in: | DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | none |
| Restrictions: | Starting in SAS 9.4M9, this option is not used. |
| 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. | |
| Requirement: | To specify this option, you must first specify MULTILOAD=YES. |
| Data source: | Teradata |
| See: | 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, Teradata MultiLoad documentation, Using MultiLoad |
Table of Contents
specifies the prefix to use when naming Teradata tables that the non-TPT MultiLoad utility uses during a bulk-loading operation.
The non-TPT MultiLoad utility uses a log table, two error tables, and a work table while loading data to a 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 you set ML_LOG=MY_LOAD.
|
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.