Usage Notes - FastExport

Teradata® FastExport Reference

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

The following table describes the things to consider when using the RUN FILE command.

RUN FILE Command Usage Notes 
Topic Usage Notes
Specifying the System Console/Standard Input Device Use the asterisk (*) character as the fileid specification for the system console/standard input (stdin) device.
The system console is the:
  • Keyboard in interactive mode
  • Standard input device in batch mode

For more information about the keyboard and standard input devices, see File Requirements.

z/OS fileid Usage Rules If a DDNAME is specified, FastExport reads data records from the specified source.
A DDNAME must obey the same construction rules as Teradata SQL column names except that:
  • The “at” character (@) is allowed as an alphabetic character
  • The underscore character (_) is not allowed

The DDNAME must obey the applicable rules of the external system and may reference a sequential or VSAM data set.

If the DDNAME represents a data source on magnetic tape, the tape may be either labeled or nonlabeled, as supported by the operating system.

Executing the RUN FILE Command After FastExport executes the RUN FILE command, it reads additional commands from the specified source until a LOGOFF command or end-of-file condition is encountered, whichever occurs first.
An end-of-file condition automatically causes FastExport to resume reading its commands and DML statements from the previously active source:
  • SYSIN for z/OS
  • stdin (normal or redirected) for UNIX and Windows operating systems
SYSIN/stdin remains the active input source after FastExport processes any user-provided invocation parameters.
Nested RUN Commands The source specified by a RUN FILE command can have up to 16 levels of nested RUN commands.