FastExport Task Activity Commands - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
17.00
Published
September 30, 2020
Language
English (United States)
Last Update
2020-09-02
dita:mapPath
ups1544831946863.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities

Task commands specify the actual processing that takes place for each FastExport task.

The following table lists the FastExport commands that perform task activities.

FastExport Command Function
BEGIN EXPORT Signifies the beginning of an export task and sets the specifications for the task sessions with the database
END EXPORT Signifies the end of an export task and initiates processing by the database
EXPORT Provides:
  • The client system destination and file format specifications for the export data retrieved from the database
  • A generated MultiLoad script file which can later reload the export data back into the database
FIELD Specifies a field of the input record that provides data values for the constraint parameters of the SELECT statement
FILLER Specifies a field of the input record that will not be sent to the database as part of the input record that provides data values for the constraint parameters of the SELECT statement
IMPORT Defines the client file that provides the USING data values for the SELECT statement
LAYOUT Specifies, in conjunction with an immediately following sequence of FIELD and FILLER commands, the layout of the file that provides data values for the USING modifier of the SELECT statement