Specifies in minutes the interval between checkpoint operations.
| Valid in: | DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | none (see “Details”) |
| Restriction: | Starting in SAS 9.4M9, this option is no longer used. |
| Requirement: | To specify this option, you must first specify MULTILOAD=YES. |
| Data source: | Teradata |
| See: | DBCOMMIT= LIBNAME option, DBCOMMIT= data set option, MULTILOAD= data set option, Teradata MultiLoad documentation, TPT_CHECKPOINT_DATA= data set option, Using MultiLoad |
Table of Contents
a numeric value that specifies the interval between checkpoint operations in minutes.
This option pertains only to the non-TPT MultiLoad facility. To work with the TPT MultiLoad utility, specify the TPT_CHECKPOINT_DATA= data set option.
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.