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

External links

• Teradata Load & Unload Utilities

See also

de:Teradata

---

Source: Wikipedia | The above article is available under the GNU FDL. | Edit this article