17.10 - ERRORS - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The ERRORS command redirects diagnostic messages to a file that you specify or to the default file STDERR. If nothing is specified, the name of the files where errors are directed displays.

Syntax

ERRORS [ { TO | INTO | OVER } { file | STDERR | ME } ]

Syntax Elements

TO
That Ferret is to write diagnostic messages to a new file or to STDERR.
If the file specified exists, Ferret returns an error.
INTO
That Ferret is to append diagnostic messages to a specified file or to STDERR.
If the file already exists, Ferret appends the error messages to the end of the file.
If the file does not exist, Ferret creates the file automatically.
OVER
That Ferret is to overwrite an existing file or STDERR with current diagnostic messages.
If the file already exists, Ferret writes over the file.
If the file does not exist, Ferret creates the file.
file
The name of the destination file for diagnostic messages.
STDERR
The default file to which Ferret writes diagnostic messages.
ME
The synonym for STDERR.

Usage Notes

When you start Ferret, it writes diagnostic messages to STDERR by default.

You can use the ERRORS command to redirect the diagnostic messages in the following ways:

  • To write to a new file only
  • To append to an existing file
  • To overwrite an existing file
  • To display on your console

If you include the file parameter in the ERRORS command, the file you specify becomes the destination for diagnostic messages redirected from STDERR.

If you type the ERRORS command without any options, Ferret shows the name of the current diagnostic messages file STDERR on your system console.

Example: Redirecting Ferret diagnostic and error messages to a file

The following example shows the format for redirecting diagnostic messages into a specific file and directory:

Ferret ==>
Errors over /home/user1/Ferret.error