ERRORFILEDIR - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

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

Syntax

ERRORFILEDIR [ Directory-name ] ;
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;