Wildcards | Teradata Vantage - Wildcards - Advanced SQL Engine - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
nbl1556236178169.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1197
lifecycle
previous
Product Category
Software
Teradata Vantage
You can use two wildcard characters anywhere in character strings representing DBS object names:
  • The “*” wildcard character means match zero or more subsequent characters
  • The “?” wildcard character means accept any legitimate character at this place in the string
Note the following examples:
  • User names “ABC*” means all users with names beginning with “ABC” (including the name “ABC”)
  • User names “A*C” means all users with names beginning with “A” and ending with “C” (including the name “AC”)
  • Table names “DB1.T?BLE*” means all tables in database DB1 with names beginning with “T_BLE” where the second character could be any character
  • Stored procedures “*.*” means all stored procedures in all databases
You can use multiples of these wildcard characters. For example:
  • User names “A*B*C” means all users with names beginning with “A” and ending with “C,” with a “B” somewhere in the middle
  • Table names “DB1.T???E” means all tables in database DB1 with names consisting of 5 characters beginning with “T” and ending with an “E”
Wildcards cannot be applied to volatile tables.