16.10 - About Defining Profile Query Bands with Ignore Query Band Values - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

If you choose the IGNORE QUERY_BAND VALUES option, which prevents a user with that profile from setting certain query band values, an empty string means that the user is not allowed to set any values for that name. For example:

CREATE PROFILE testprofile AS
  			       IGNORE QUERY_BAND VALUES = ‘IMPORTANCE=;’; 

Trailing spaces are always removed from names and values, so if a value is specified as several spaces, the spaces will be removed and the value will be an empty string.

To specify multiple values for a name, specify each name-value pair separately, as in the following example. When a user with salesprofile issues a SET QUERY_BAND FOR SESSION/TRANSACTION request, the following example causes Teradata Database to ignore the values WARM and HOT for TVSTemperature and issue an error message.