ML_RESTART= Data Set Option

Specifies the name of a temporary table that MultiLoad uses to track checkpoint information.

Valid in:	DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
Default:	none
Restriction:	Do not use ML_RESTART= with ML_LOG=, which provides a common prefix for all temporary tables that the Teradata MultiLoad utility uses.
Requirements:	To specify this option, you must first set MULTILOAD=YES. When you restart a failed MultiLoad job, you must specify the same application table from the earlier run so that the MultiLoad job can restart correctly. Using ML_RESTART=, ML_ERROR1=, and ML_WORK=, you must also specify the same log table, acquisition error table, and work table upon restarting.
Data source:	Teradata
See:	ML_ERROR1= data set option, ML_ERROR2 data set option, ML_LOG= data set option, ML_WORK= data set option, MULTILOAD= data set option, Using MultiLoad

Syntax

Details

Syntax

ML_RESTART=temporary-table-name

Syntax Description

temporary-table-name: specifies the name of the temporary table that the Teradata MultiLoad utility uses to track checkpoint information.

Details

Use this option to specify the name of a table to store checkpoint information. Upon restart, ML_RESTART= is used to specify the name of the log table that you used for tracking checkpoint information in the earlier failed run.

For more information about the temporary table names that the Teradata MultiLoad utility uses, see the Teradata documentation on the MultiLoad utility.