Definition - FastExport

Teradata FastExport Reference

Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

A FastExport job script, or program, is a set of FastExport commands and Teradata SQL statements that select and export data from Teradata Database.

Each FastExport job includes a number of support commands that establish and maintain the FastExport support environment, and a number of task commands that perform the actual database select and export operations.

A complete FastExport job includes:

  • Invoking FastExport
  • Logging on to Teradata Database and establishing the FastExport support environment
  • Specifying the FastExport tasks
  • Logging off from Teradata Database and terminating FastExport
  • 1 Invoke FastExport, specifying desired runtime options:

  • Normal or abbreviated (brief) printout
  • Character set
  • Session limits
  • Alternate error message file
  • Standard input file/device
  • Standard output file/device
  • Alternate run file
  • 2 Establish the FastExport support environment as indicated in Table 22.


    Table 22: Commands for Establishing FastExport Support Environment 




    Specify the restart log table that maintains checkpoint information for the FastExport job.


    Specify the form of the DATE data type specifications for the FastExport job.


    Establish a session with Teradata Database.


    Transfer processing control to an alternate run file.


    Specify an alternate destination for FastExport output messages.


    Submit an operating system command to the client system.

    Teradata SQL statements

    Submit a supported Teradata SQL statement to Teradata Database.

    At a minimum, this portion of the FastExport job must include:

  • A LOGTABLE command to specify the restart log table
  • A LOGON command to provide a logon string that is used to connect all Teradata SQL and FastExport sessions with Teradata Database
  • State these commands in any order, but both commands must appear before any task commands in the FastExport job script.

    3 Specify the FastExport task as indicated in Table 23.


    Table 23: Commands for Specifying the FastExport Task 




    Signify the beginning of an export task specification.


    Specify, in conjunction with immediately following FIELD and FILLER commands, the layout of the input data records on the client system. (The layout specification will be referenced in a subsequent IMPORT command.)


    Specify a field of the input record to be used to supply values for variables in the SELECT statement.


    Describe a field of the input data record that is not referenced, but used only to indicate the relative position of the following FIELD data.


    Specify the destination file and format specifications for export data retrieved from Teradata Database.


    Specify the client file that provides the USING values for the SELECT statement.


    Specify the row data to be exported from Teradata Database.


    Signify the end of the FastExport task and initiate the task processing.

    At a minimum, this portion of the FastExport job must include:

  • A BEGIN EXPORT command
  • A select request
  • An EXPORT command
  • An END EXPORT command
  • 4 To specify another FastExport task:

  • Use the support commands listed in Step 2 to modify the FastExport support environment for the next task
  • Use the task commands listed in Step 3 to specify the next task
  • Repeat these steps for each task in the FastExport job.

    5 Use the LOGOFF command to disconnect all active sessions with Teradata Database and terminate FastExport on the client system.