DISPLAY - Parallel Data Pump

Teradata Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

DISPLAY

Purpose  

The DISPLAY command can be used to write messages to the specified destination.

Syntax  

where

 

Syntax Element

Description

'text'

Text to be written to the specified output destination

fileid

Data source of the external system.

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

UNIX and Windows Systems

infilename (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.

z/OS

a true DDNAME.

If DDNAME is specified, Teradata TPump reads data records from the specified source.

A DDNAME must obey the same rules for its construction as Teradata SQL column names, except that:

  • the “at” sign (@) is allowed as an alphabetic character
  • the underscore (_) is not allowed
  • A DDNAME must obey the applicable rules of the external system and may reference a sequential or VSAM data set.

    If DDNAME represents a data source on magnetic tape, the tape may be either labelled or nonlabelled (if the operating system supports it).

    Usage Notes  

    Utility variables are replaced by their values before text is displayed. This is done by preceding the variable name with an ampersand (&). To display the name of a utility variable, code two “&”s instead of one.

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

    In UNIX systems, if outfilename is used to redirect stdout as well as the file in a DISPLAY command, the results written to outfilename may be incomplete due to conflicting writes to the same file.

    On UNIX systems, use an asterisk (*) 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