ROUTE
Purpose
The ROUTE command identifies the destination of various outputs produced by Teradata TPump.
Syntax
where
|
Syntax Element |
Description |
|
MESSAGES |
Preferred location where the messages be redirected (normally written to DDNAME SYSPRINT in z/OS or stdout in UNIX systems); that is, sent to an additional destination, or both |
|
fileid1 and fileid2 |
Alternate message destination in the external system UNIX and Windows Systems 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. |
|
ECHO |
Additional destination, with a fileid specification Use the ECHO keyword to specify, for example, that messages be captured in a file (fileid2) while still being written to the terminal. Note: The ECHO OFF specification cancels the additional file specification of a previously established ECHO destination. |
Usage Notes
In z/OS, fileid is a true DDNAME; and in the UNIX OS, it is a file pathname. If DDNAME is specified, Teradata TPump writes data records to the specified destination. 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 and the underscore ( _ ) is not allowed. The DDNAME must also 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).
On UNIX systems, an asterisk (*) can be used as the fileid1 or fileid2 specifications to route messages to the system console/standard output (stdout) device. The system console is the:
or
Example
.ROUTE MESSAGES TO FILE OUTPUT WITH ECHO TO FILE SYSOUT;
ECHO, when specified with OFF, stops routing output to the previously established echo destination.
Example
.ROUTE MESSAGES FILE OUTPUT;
The messages are written to the file designated by OUTPUT from this point unless redirected by another ROUTE command.
In UNIX systems, if “outfilename” is used to redirect “stdout,” and also as the file in a ROUTE WITH ECHO command, the results written to “outfilename” may be incomplete due to conflicting writes to the same file.