15.00 - Macro Support for Query Bands - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Macro Support for Query Bands

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 request aborts and 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. See the CREATE MACRO/REPLACE MACRO “Example 10: Setting the Transaction Query Band Using a Parameter” topic in SQL Data Definition Language.