TD_PAUSE_ACQ= Table Option

Forces a pause between the acquisition phase and the application phase of a load job.

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

Syntax

TD_PAUSE_ACQ= YES | NO

Arguments

YES

specifies to pause the load job after the acquisition phase and skip the application phase.

Restriction This option is provided for the Load and Update operators. It is ignored by the Stream operator.

NO

distributes all of the rows that were sent to the Teradata database during the acquisition phase to their final destination on the AMPs. This is the default value.