17.00 - Example: Modifying Profile to Set Default Query Band Value and Query Band Value to Ignore - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)
In this example, the user's profile query band is set to TVSTemperature=WARM. If the user sets the query band to TVSTemperature=HOT, the name-value pair is discarded from the query band.
    MODIFY PROFILE salesprofile AS,
          QUERY_BAND = ’TVSTemperature=WARM;’ DEFAULT,
          IGNORE QUERY_BAND VALUES =’TVSTemperature=HOT’;