20.FastExport Utility

FastExport Utility

 

FastExport is a command-driven utility that uses multiple sessions to

quickly transfer large amounts of data from tables and views on the

Teradata Database to a client-based application.

You can export data from any table or view to which you have the

SELECT access privilege. The destination for the exported data can be:

·

A file on your channel-attached or network-attached client system.

·

An Output Modification (OUTMOD) routine you write to select, validate,

and preprocess the exported data.

How it Works ?

FastExport processes a series of FastExport commands and Teradata

SQL statements you enter, usually as a batch mode job script. The

FastExport commands provide the session control and data handling

specifications for the data transfer operations. The Teradata SQL

statements perform the actual data export functions on the Teradata

tables and views.

What it Does ?

When you invoke FastExport, the utility executes the FastExport

commands and Teradata SQL statements in your FastExport job script.

These direct the FastExport utility to:

1. Log you on to Teradata for a specified number of sessions, using your

username, password and tdpid/acctid information.

2. Retrieve the specified data from Teradata, in accordance with your

format and selection specifications.

3. Export the data to the specified file or OUTMOD routine on your client

system.

4. Log you off of Teradata.