BEGIN LOADING | Syntax | Teradata FastLoad - 17.10 - Syntax - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

BEGIN LOADING syntax diagram

where the following is true:

dbname
Name of the database in which each table resides.
Teradata FastLoad uses the current default database if a database name is not included with the table name specifications.
To refer to more than one database, include the database name with the table name specifications.
tname1
Name of the Teradata FastLoad target table to receive the data from the client system.
A name that duplicates the name of an existing table cannot be used unless restarting a paused Teradata FastLoad job. The name must be a new table name.
errortname1
Name of the first error table.
A name that duplicates the name of an existing table cannot be used unless restarting a paused Teradata FastLoad job. The name must be a new table name.
errortname2
Name of the second error table.
A name that duplicates the name of an existing table cannot be used unless restarting a paused Teradata FastLoad job. The name must be a new table name.
CHECKPOINT
Enables the checkpoint option.
integer
Value that specifies the number of rows transmitted to the database between checkpoints using the CHECKPOINT keyword to enable the checkpoint option.
(The checkpoint option is not enabled if it is not included the CHECKPOINT keyword in the BEGIN LOADING command.)
For more information about specifying the CHECKPOINT integer value, see Usage Notes.
INDICATORS
Places null indicator bits at the front of each record.
The number of fields in each record determines how many bytes contain null indicators, as described in the Indicators topic under Usage Notes.
  • The INDICATORS specification cannot be used when loading records in variable-length text format. If the Teradata FastLoad job script specifies INDICATORS in the BEGIN LOADING command and the VARTEXT option in the SET RECORD command, the utility terminates with an error message.
  • INDICATORS mode is not recommended when using TEXT record format. Please use UNFORMATTED record format instead.
DATAENCRYPTION value
Enables data encryption for a Teradata FastLoad job.
The options for value are:
  • ON = The requests will be encrypted.
  • OFF = The requests will not be encrypted.
This option will apply only to the BEGIN LOADING request and the requests after the BEGIN LOADING command.
Using this option overwrites the data encryption settings specified by both the runtime parameters and in the floadcfg.dat configuration file.
NODROP
Retains the error table at the end of a job, even if the error table is empty.
When using this option, be careful to manually drop all error tables before running additional jobs that use the same tables. Failure to do so results in database errors.
(Default) If this option is not specified, the error table is dropped at the end of a job if the error table is empty.