15.00 - Macro Support for Query Bands - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Programming Reference

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.