Query Band Examples - Teradata Preprocessor2

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;