Example: SYSTEM| FastExport utility - Example: SYSTEM - FastExport

Teradata® FastExport Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
jaa1691573250507.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
rto1478610027076
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;