About custom macros

A custom macro is a query that you create using either a IBM® Expression, raw SQL, or raw SQL that includes a value. Custom macros also support variables, which makes them far more powerful than the stored queries they are designed to replace.

You can save a custom macro and use it in configuring processes in a flowchart, and in defining derived fields.

Support for raw SQL improves performance, allowing complex transactions to be carried out in the database rather than having the raw data filtered and manipulated in the application server.

Campaign supports the following three types of custom macros, which in turn support an unlimited number of variables:

Custom macros that use a IBM® Expression

Custom macros that use raw SQL

Custom macros that use raw SQL and include a specified value

Since non-technical users are able to use custom macros, when you create a custom macro you should describe how it works very carefully, place similar kinds of macros in special folders, and so on, to reduce the possibility that someone might use a custom macro incorrectly and retrieve data that they were not expecting.

To create a custom macro

Guidelines for using custom macros

To manage a custom macro