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.