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:
You cannot set a session query band using a macro parameter. Otherwise, the request aborts and the system returns an error to the requestor.
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.