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. |