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;’;