RUN | Usage Notes | Teradata FastLoad - Usage Notes - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
ruk1608578422758.ditamap
dita:ditavalPath
vax1619194969834.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

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

Usage Notes for Run 
Topic Usage Notes
z/OS fileid Usage Rules If a DDNAME is specified, Teradata FastLoad 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 Command After Teradata FastLoad executes the RUN 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 Teradata FastLoad 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 systems
SYSIN/stdin remains the active input source after Teradata FastLoad processes any user-provided invocation parameters.
Nested RUN Commands The source specified by a RUN command can have up to five levels of nested RUN commands.