Example: SYSTEM - FastExport

Teradata® FastExport Reference

Product
FastExport
Release Number
17.00
Published
September 30, 2020
Language
English (United States)
Last Update
2020-09-02
dita:mapPath
ups1544831946863.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following example deletes the file /home/fexpuser/tests/out1 if it exists. The command string then creates a new /home/fexpuser/tests/out1 file to contain the exported records from the SELECT statement.

.SYSTEM 'rm -f /home/fexpuser/tests/out1';
.BEGIN EXPORT;
SEL * FROM table1;
.EXPORT OUTFILE /home/fexpuser/tests/out1;
.END EXPORT;