SYSTEM - FastExport

Teradata FastExport Reference

Product
FastExport
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2410
lifecycle
previous
Product Category
Teradata Tools and Utilities

The SYSTEM command submits an operating system command to the client environment during a FastExport operation.

where:

 

Syntax Element

Description

oscommand

Any legal command in the client operating system

The SYSTEM command suspends the current FastExport operation to execute the client operating system command.

When the client operating system command completes, FastExport displays the return code from the invoked command and updates the &SYSRC variable.

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;