ERRORS - Advanced SQL Engine - Teradata Database

Purpose

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 } ]

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.

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