Sets or removes a query band for the current session or transaction.
Middle-tier applications, through which end users access Vantage, can be programmed to use the SET QUERY_BAND statement to attach metadata to end user SQL queries.
Vantage logs query bands in DBQL, providing opportunities for subsequent analysis of queries.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
If you need to submit SET QUERY_BAND requests to set a proxy user, the privilege GRANT CONNECT THROUGH must be granted on your trusted user name to the proxy user.
If you do not need to submit SET QUERY_BAND requests to set a proxy user, you need no privileges granted on your trusted name.