Data Set Options for Relational Databases |
Specifies the interval between checkpoint
operations in minutes.
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
|
ML_CHECKPOINT=checkpoint-rate
|
- checkpoint-rate
-
a numeric value that specifies the interval between checkpoint
operations in minutes.
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.
For more information about using checkpoints and restarting MultiLoad
jobs, see the
MULTILOAD= Data Set Option.
DBCOMMIT= LIBNAME Option
DBCOMMIT= Data Set Option
Using MultiLoad
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.