Data Set Options for Relational Databases |
Default value: | none (see "Details") |
Valid in: | DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software) |
DBMS support: | Teradata |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
ML_CHECKPOINT=checkpoint-rate |
a numeric value that specifies the interval between checkpoint operations in minutes.
Details |
To specify this option, you must first set MULTILOAD=YES.
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 are loaded.
ML_CHECKPOINT= functions very similarly to CHECKPOINT in the native Teradata MultiLoad utility. However, it differs from DBCOMMIT=, which is disabled for MultiLoad to prevent any conflict.
See the Teradata documentation on the MultiLoad utility for more information about using MultiLoad checkpoints.
See Also |
For more information about using checkpoints and restarting MultiLoad jobs, see the MULTILOAD= Data Set Option.
Using MultiLoad
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.