RUN - FastLoad

Teradata FastLoad Reference

Product

FastLoad

Release Number

15.10

Language

English (United States)

Last Update

2018-10-07

dita:id

B035-2411

lifecycle

Product Category

Teradata Tools and Utilities

The RUN command invokes a specified external source as the current source of commands and statements.

where

Syntax Element

Description

fileid

Data source of the external system.

The external system DD (or similar) statement specifies a file.

In z/OS, the fileid is a DDNAME.

In UNIX and Windows systems, the fileid is the path name for a file and supports size of up to 1024.

FILE

The keyword FILE is optional.

Table 48 describes the things to consider when using the RUN command.

Table 48: 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 Note: 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.