Syntax for Setting Query Band
EXEC SQL SET QUERY_BAND = 'pair_name=pair_value;[...pair_name=pair_value;]'|NONE [UPDATE] FOR SESSION|TRANSACTION;
Syntax for Removing Query Band
EXEC SQL SET QUERY_BAND = NONE FOR SESSION|TRANSACTION;
| Variable or Keyword | Description |
|---|---|
| pair_name | This variable is the name component of a query band specification. |
| pair_value | This variable is the value component of a query band specification. |
| UPDATE | (Optional) This keyword adds a name-value pair to the current session or transaction. |