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.