15.10 - RepCaptureRulesV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

RuleSetName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

RepRulesetTbl.RuleSetName (Composite USI)

GroupName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

RepGroup.GroupName

ObjectKind

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

RepCaptureRulesTbl.ObjectKind (NUPI)

DefaultOpt

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

RepCaptureRulesTbl.DefaultOption

LikePattern

VARCHAR(300)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(300)

RepCaptureRulesTbl.LikePattern

LikeEscape

CHAR(1)

UNICODE

NOT CASESPECIFIC

X(1)

RepCaptureRulesTbl.LikeEscape

NotLikePattern

VARCHAR(300)

UNICODE

NOT CASESPECIFIC

X(300)

RepCaptureRulesTbl.NotLikePattern

NotLikeEscape

CHAR(1)

UNICODE

NOT CASESPECIFIC

X(1)

RepCaptureRulesTbl.NotLikeEscape

The following SELECT statement selects all non-default rules defined for a table object:

==> SELECT GroupName, RulesetName, LikePattern, LikeEscape, NotLikePattern, NotLikeEscape
  FROM DBC.RepCaptureRulesV
  WHERE DefaultOpt = 'N' AND ObjectKind = 'T'
  ORDER BY GroupName, RulesetName, LikePattern, LikeEscape,
  NotLikePattern, NotLikeEscape;

Result:

 GroupName repgroup
  RuleSetName prmtablers
  LikePattern repuser.prmtab%
  LikeEscape ?
NotLikePattern ?
 NotLikeEscape ?
   GroupName repgroup
  RuleSetName subtablers
  LikePattern repuser.subtab%
  LikeEscape ?
NotLikePattern repuser.subtabx%
NotLikeEscape ?