FastExport

FastExport is a Teradata utility.

Teradata FastExport – Data Export
Teradata FastExport, is the reverse of the FastLoad utility. This high-speed utility quickly exports large data sets from Teradata tables or views to a client system for processing, generating large reports, or for loading data into a smaller database. Like all Teradata load utilities, FastExport can export data to both channel- or network-attached client systems.

FastExport also provides session control and data handling specifications for the data transfer operations.

Features

 * High-performance data unload in client format

Supported Platforms

 * NCR UNIX SVR4 MP-RAS™
 * IBM z/OS (MVS)
 * Microsoft® Windows® 2000, XP, and Server 2003
 * Sun Solaris SPARC
 * HP-UX
 * IBM AIX
 * Red Hat Linux
 * SUSE Linux Enterprise Server from Novell

Description
FastExport is a command-driven utility that uses multiple sessions to quickly transfer large amounts of data from tables and views of the Teradata Relational Database Management System (RDBMS) 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

Note: Full tape support is not available for any function in FastExport for network-attached client systems.

A Sample Script
.LOGTABLE utillog;                 /*define restart log */

.LOGON tdpz/user,pswd;             /*DBC logon string */

.BEGIN EXPORT                      /*specify export function */ SESSIONS 20;                       /*number of sessions to be used */

.LAYOUT UsingData;                 /*define the input data */ .FIELD ProjId * Char(8);           /*values for the SELECT */ .FIELD WkEnd * Date;               /*constraint clause. */

.IMPORT INFILE ddname1             /*identify the file that */ LAYOUT UsingData;                  /*contains the input data */

.EXPORT OUTFILE ddname2;           /*identify the destination */ /*file for exported data */ SELECT EmpNo, Hours FROM CHARGES   /*provide the SQL SELECT */ WHERE WkEnd = :WkEnd               /*statement with values */ AND Proj_ID = :ProjId              /*provided by the IMPORT */ ORDER BY EmpNo;                    /*command */

.END EXPORT;                       /*terminate the export */ /* operation */ .LOGOFF;                           /*disconnect from the DBS */