TD_CHECKPOINT= Table Option

Specifies when the TPT operation issues a checkpoint or savepoint to the database.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within the BULKOPTS= Table Option
Data source: Teradata

Syntax

TD_CHECKPOINT= number

Arguments

number

specifies the number of rows after which the TPT operation issues a checkpoint or savepoint to the database. The default is 0, which means no checkpoint is taken. All rows are saved at the end of the job.