Macro Support for Query Bands - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

Macro support for the SET QUERY_BAND statement is different depending on whether the Query Band is set for a session or a transaction:

  • SET QUERY_BAND … FOR SESSION is supported in the same way that other DDL statements are.

    You cannot set a session query band using a macro parameter. Otherwise, the system returns an error to the requestor.

  • SET QUERY_BAND … FOR TRANSACTION is not supported when it is the only statement in a macro. It is supported when there are other statements in the macro.

    You can set a transaction query band using a macro parameter, including the QUESTION MARK parameter.