Wildcards | Teradata Vantage - Wildcards - Analytics Database - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Workload Management
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aji1628112479055.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1197
Product Category
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.