17.10 - Macro Support for Query Bands - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
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.