17.10 - ERRORFILEDIR - 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)

Displays or changes the location of the error file for the current CheckTable session.

Syntax

ERRORFILEDIR [ Directory-name ] ;

Syntax Elements

Directory-name
The name of the directory location of the error file.

Usage Notes

If ERRORFILEDIR is specified by itself, then the current error file location displays.

The default error file location is the PDE Temp directory.

To determine the PDE Temp directory path, enter pdepath -S on the Linux command line.

If Directory-name is specified, the error file location for the current CheckTable instance is set to this path.

The Directory-name can be a fully qualified directory name (for example, “/var/tmp/checktable”) or a relative path directory name (such as “checktable” or “checktable/errors”). For a relative name, the root directory is the PDE Temp directory.

Example: Displaying the current error file location

To display the current error file location:

ERRORFILEDIR;

Example: Changing the error file location

To change the error file location:

ERRORFILEDIR CheckErrorFiles;
ERRORFILEDIR /var/tmp/CheckErrorFiles;