16.10 - ERRORLIST UPDATE - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty

Purpose

Creates or updates a routing error list either by specific codes or by importing directly from a set of files.

Syntax

ERRORLIST UPDATE ErrorListName[[ IMPORT [file] [RESUBMIT filename][RETRY THEN RESUBMIT filename[EXIT filename]] |{RESUBMIT|RETRY|RETRY THEN RESUBMIT|EXIT | REMOVE { code | start-end } [ 'comment' ]];

Parameters

errorlistname
Unique TDPID that identifies the Unity error list name.
EXIT
file
Filename of the error list to import.
The format must match the format of the file created using ERRORLIST EXPORT.
If the full path is not specified, the file is read in the directory from which unityadmin was launched.
filename
Filename of the error file to import. The format of this file must match the original error code file created using sockclient.
The format of this file is: <error code> [# <comment>]

Example of a RESUBMIT file:

 1068 # Resubmitable error due to lost connection to underlying system
 2507
 4505 # Resubmitable error due to nonexistent session on underlying system
code
The error code to update.
IMPORT
Imports Errorlist.
RESUBMIT
Tries the query on another system.
RETRY THEN RESUBMIT
Combination of retry and resubmit.
EXIT
Terminates the session.
REMOVE
Removes the query.
start
Start of the error code range when updating a rule that affects a range of error codes.
end
End of the error code range when updating a rule that affects a range of error codes.

Examples

At the unityadmin prompt:

Input Description
ERRORLIST UPDATE from_QD IMPORT RESUBMIT err_pref.txt EXIT err_exit.txt; Import an existing rule created using an earlier version of sockclient into Unity.
ERRORLIST UPDATE myErrorList1 IMPORT myEditedList.txt; Import changes that were made to the error list file that was exported using "ERRORLIST EXPORT."
ERRORLIST UPDATE myErrorList1 RESUBMIT 2543-2545 'Operation not allowed error'; Add a new failover rule for a range of error code to an existing error list profile.
ERRORLIST UPDATE myErrorList1 REMOVE 2507; Remove a rule from an existing error list profile.