Definition - FastExport

Teradata FastExport Reference

Product
FastExport
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2410
lifecycle
previous
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 

    Command

    Description

    LOGTABLE

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

    DATEFORM

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

    LOGON

    Establish a session with Teradata Database.

    RUN FILE

    Transfer processing control to an alternate run file.

    ROUTE MESSAGES

    Specify an alternate destination for FastExport output messages.

    SYSTEM

    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 

    Command

    Description

    BEGIN EXPORT

    Signify the beginning of an export task specification.

    LAYOUT

    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.)

    FIELD

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

    FILLER

    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.

    EXPORT

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

    IMPORT

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

    SELECT

    Specify the row data to be exported from Teradata Database.

    END EXPORT

    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.