Wildcards | Teradata Vantage - 17.00 - Wildcards - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide

prodname
Advanced SQL Engine
Teradata Workload Management
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1197-170K
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.