Specifies the name of a temporary table that non-TPT MultiLoad uses to store intermediate data.
| 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 no longer used. |
| Do not use ML_WORK= with ML_LOG=, which provides a common prefix for all temporary tables that the Teradata MultiLoad utility uses. | |
| 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_LOG= data set option, ML_RESTART= data set option, MULTILOAD= data set option, Teradata MultiLoad documentation, TPT_WORK_TABLE= data set option, Using MultiLoad |
Table of Contents
specifies the name of a temporary table that non-TPT MultiLoad uses to store intermediate data that the MultiLoad utility receives during bulk loading.
This option pertains to the non-TPT MultiLoad facility. To work with the TPT MultiLoad utility, use the TPT_WORK_TABLE= data set option.
Use the ML_WORK= data set option to specify the name of the table to use for tracking intermediate data that the non-TPT MultiLoad utility received during bulk loading. When you restart the job, use ML_WORK= to specify the name of the table for tracking intermediate data during a previously failed MultiLoad job.