ROUTING LIST - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
ipb1476817227329.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

List of existing routing rules and the properties that define each rule.

Syntax

ROUTING LIST [RoutingName];

Parameters

RoutingName
Name of the routing rule. If you do not specify a routing rule name, all existing routing rule definitions display.

Examples

Routing rule definitions display in the following format:

<RoutingName> [REJECT LOGON] | [ [READ [ALL | <tdpid> [, <tdpid>, ...] ] [PREFERRED ] ] [WRITE [ALL | <tdpid> [, <tdpid>,...] ] [CREATE PREFERRED | BALANCED] ] [ERRORLIST <ErrorListName>] ]

This example shows output for a ROUTING LIST command where the existing rules are DefaultRouting and rejectRouting.

unityadmin>  ROUTING LIST; 
DefaultRouting READ WRITE
MSIUser READ WRITE CREATE BALANCED ERRORLIST MsiErrorList
readSys1Only READ sys1 WRITE ERRORLIST myErrorList1
rejectRouting REJECT LOGON