ML_WORK= Data Set Option

Specifies the name of a temporary table that MultiLoad uses to store intermediate data.

Valid in:	DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
Default:	none
Restriction:	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 set 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, Using MultiLoad

Syntax

Details

Syntax

ML_WORK=temporary-table-name

Syntax Description

temporary-table-name: specifies the name of a temporary table that MultiLoad uses to store intermediate data that the MultiLoad utility receives during a bulk-load operation.

Details

Use this option to specify the name of the table to use for tracking intermediate data that the MultiLoad utility received during a bulk-load operation. 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.

For more information about temporary table names that the MultiLoad utility uses and what is stored in each, see the Teradata MultiLoad reference.