16.10 - OUTPUT - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

The OUTPUT command redirects Filer output to a file you specify or to the default file, stdout.

Syntax



TO
Specifies that Filer is to redirect output to a new file or to STDOUT.
If the file exists, Filer returns an error.
INTO
Specifies that Filer is to append output to an existing file specified by file or to STDOUT.
If the file exists, Filer appends the output to the end of the file.
If the file does not exist, Filer creates the file.
OVER
Specifies that Filer is to overwrite an existing file or STDOUT with new Filer output.
If the file exists, Filer writes over the file.
If the file does not exist, Filer creates the file.
file
The name of a file you specify as the destination of Filer output.
STDOUT
The default file to which Filer writes output.
ME
A synonym for STDOUT.

Usage Notes

When you first start Filer, diagnostic messages are written to STDOUT by default. You can use the OUTPUT command to redirect Filer output in any of the following ways:

  • To write to a new file only
  • To append an existing file
  • To overwrite an existing file
  • To display on your console
The output file is located on the node that runs the control AMP. To determine which node is running the control AMP, use the STATUS command of the Vproc Manager utility. The control AMP is designated under the Logical Configuration with an asterisk.

When Filer redirects output to a file, all input and diagnostic messages are echoed to the output file as well as to their usual destinations.

If you include the file parameter in the OUTPUT command, Filer uses that parameter as the destination for output redirected from STDOUT.

If you type the OUTPUT command without any options, Filer displays the name of the current output file STDOUT to your system console.