17.05 - Example: Creating Profile with System Default Query Band Value and Query Band Value to Ignore - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1144-175K
Language
English (United States)
In this example, the profile QUERY_BAND does not contain a TVSTemperature name-value pair. With this profile, suppose the session has the system default TVSTemperature setting as defined in the related DBS Control parameter. The user can execute an application that sets the QUERY_BAND TVSTemperature to WARM or COLD.
    CREATE PROFILE salesprofile AS,
          QUERY_BAND = ‘GROUP=WestCoast;’ DEFAULT,
          IGNORE QUERY_BAND=’TVSTemperature=HOT;’;