FastExport
From Wikipedia, the free encyclopedia
FastExport is a Teradata utility.
Contents |
[edit] 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.
[edit] Features
- High-performance data unload in client format
[edit] 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
- RedHat Linux
- SUSE Linux Enterprise Server from Novell
[edit] 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.
[edit] 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 */
