16.20 - Macro Support for Query Bands - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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.