17.10 - Example: Creating Profile that Ignores pair-name with Any pair-value - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
This example specifies the name IMPORTANCE without a value, that is, an empty string. This causes a SET QUERY_BAND statement to discard the name-value with the matching name and any value.
    CREATE PROFILE testprofile AS
          IGNORE QUERY_BAND VALUES = ‘IMPORTANCE=;’;