RUN FILE - 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 RUN FILE command invokes the specified external file as the current source for utility 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 UNIX OS and Windows, the fileid is the path name for a file

    • If the path name has embedded white space characters, enclose the entire path name in single or double quotes.

    If the path name is enclosed by single quotation marks and there is an embedded single quotation mark, then an escape character (single quotation mark) needs to precede the embedded single quotation mark. Likewise, if the path name is enclosed by double quotation marks and there is an embedded double quotation mark, then an escape character (double quotation mark) needs to precede the embedded double quotation mark.

    If the path name contains single or double quotation marks, it should be enclosed in either single or double quotation marks.

  • In z/OS, the fileid is a DDNAME.

    • IGNORE charpos1 and charpos2

    Start and end character positions of a field in each input record that contains extraneous information. If one of the following is specified:

  • charpos1, then FastExport ignores only the single specified character
  • charpos1 THRU, then FastExport ignores all characters from charpos1 through the end of the record
  • THRU charpos2, then FastExport ignores all characters from the beginning of the record through charpos2
  • charpos1 THRU charpos2, then FastExport ignores all characters from charpos1 through charpos2
    		•

    Table 43 describes the things to consider when using the RUN FILE command.

     

    Table 43: 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” on page 13.

    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

    • Note: 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.