Usage Notes - 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 table describes the things to consider when using the ROUTE MESSAGES command.

ROUTE MESSAGES Command Usage Notes 
Topic Usage Notes
Specifying the System Console/Standard Output Device Use the asterisk (*) character as the fileid1 or fileid2 specifications to route messages to the system console/standard output (stdout) device.
The system console is the:
  • Display screen in interactive mode
  • Standard output device in batch mode

For more information about the display screen and standard output devices, see File Requirements.

Default Message Destinations If the ROUTE MESSAGES command is not used, FastExport writes output messages to:
  • DDNAME SYSPRINT in z/OS
  • stdout in UNIX OS and Windows
z/OS fileid Usage Rules If a DDNAME is specified, FastExport writes messages to 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.