Because this CREATE PROFILE statement does not include the DEFAULT clause, the profile query band is set to NOT DEFAULT.
CREATE PROFILE salesprofile AS, SPOOL = 2e6*(HASHAMP()+1), QUERY_BAND = ‘GROUP=sales;AREA=retail;’;
If a user with the profile salesprofile issues the following statement, the GROUP=production pair is removed from the query band because the profile query band pairs cannot be overwritten.
SET QUERY_BAND = ‘GROUP=production;’ FOR SESSION;