ML_CHECKPOINT= Data Set Option

Specifies the interval between checkpoint operations in minutes.

Valid in:	DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
Default:	none (see “Details”)
Requirement:	To specify this option, you must first set MULTILOAD=YES.
Data source:	Teradata
See:	DBCOMMIT= LIBNAME option, DBCOMMIT= data set option, MULTILOAD= data set option [using checkpoints, restarting MultiLoad jobs], Using MultiLoad

Syntax

Details

Syntax

ML_CHECKPOINT=checkpoint-rate

Syntax Description

checkpoint-rate: a numeric value that specifies the interval between checkpoint operations in minutes.

Details

If you do not specify a value for ML_CHECKPOINT=, the Teradata Multiload default of 15 applies. If ML_CHECKPOINT= is between 1 and 59 inclusive, checkpoints are taken at the specified intervals, in minutes. If ML_CHECKPOINT= is greater than or equal to 60, a checkpoint occurs after a multiple of the specified rows is loaded.

ML_CHECKPOINT= functions very similarly to CHECKPOINT in the native Teradata MultiLoad utility. However, it differs from DBCOMMIT=. Both DBCOMMIT= and its alias, CHECKPOINT, are disabled to prevent any conflict.

See the Teradata documentation on the MultiLoad utility for more information about using MultiLoad checkpoints.