To set the priority at 1 for a high workload in the current session:
EXEC SQL SET QUERY_BAND = 'priority=1;workload=high;' FOR SESSION;
To set the same values for the current transaction:
EXEC SQL SET QUERY_BAND = 'priority=1;workload=high;' FOR TRANSACTION;
To set the proxy user cluster with proxy role role1 for the current session:
EXEC SQL SET QUERY_BAND = 'PROXYUSER=cluser1; PROXYROLE=role1;' FOR SESSION;
To set the proxy user cluster with proxy role role1 for the current transaction:
EXEC SQL SET QUERY_BAND = 'PROXYUSER=cluser1; PROXYROLE=role1;' FOR TRANSACTION;
To add a name-value pair to the current session, use UPDATE in a second SET QUERY_BAND statement:
EXEC SQL SET QUERY_BAND = 'city=san diego;' FOR SESSION; ... EXEC SQL SET QUERY_BAND = 'state=california;' UPDATE FOR SESSION;
To remove query banding from the current session:
EXEC SQL SET QUERY_BAND = NONE FOR SESSION;
To remove query banding from the current transaction:
EXEC SQL SET QUERY_BAND = NONE FOR TRANSACTION;