To assign values to a query band in a profile, submit a CREATE/MODIFY PROFILE request. The profile query band is automatically set for the session at logon. You can submit a MODIFY PROFILE QUERY_BAND = NULL request at any time to remove the query band from the profile. For the syntax and more extensive examples, see SQL Data Definition Language.
If the transaction, session, and profile query bands have the same name but with different values, the name/value pair used for workload management classification is the first one found in a query band searched in the following order:
- Transaction query band
- Session query band
- Profile query band