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 loadutilities, 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

upported 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 */

External links

* [http://www.teradata.com/t/page/94244/index.html/ Teradata Load & Unload Utilities]

ee also