DISPLAY - FastExport

Teradata FastExport Reference

Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

The DISPLAY command writes messages to a specified destination.



Syntax Element



Text to be written to the specified output destination


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 OS and Windows, fileid is the path name for a file.
  • If the path name contains single or double quotation marks, it should be enclosed in either single or double quotation marks.

    Table 28 describes the things to consider when using the DISPLAY command.


    Table 28: DISPLAY Command Usage Notes 


    Usage Notes

    Conflicting Write Operations on Network‑attached Systems

    On network‑attached client systems, if the same file is specified to redirect stdout as the file in a DISPLAY command, the results may be incomplete due to conflicting write operations to the same file.

    Displaying Apostrophes in the Text String

    To display an apostrophe within the text string, use two consecutive apostrophes (single quotes) to distinguish it from both the single quotes enclosing the string and a regular double‑quote character.

    Specifying the System Console/Standard Output Device

    The asterisk (*) character can be used as the fileid specification to direct the display 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” on page 13.

    Utility Variables

    Utility variables are replaced by their values before text is displayed. This is done by preceding the variable name with an ampersand (&) character.

    To display the name of a utility variable, code two ampersand characters instead of one.

    z/OS fileid Usage Rules

    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.