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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
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;’;