Custom macros
A custom macro is a query that you create using an
IBM
®
Expression, raw SQL, or raw SQL that includes a value. Custom macros support the use of variables.
You can save a custom macro so it is available when configuring processes in a flowchart and 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 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. This approach can help reduce the possibility that someone might use a custom macro incorrectly and retrieve data that they were not expecting.
Creating custom macros
Guidelines for using custom macros
Organizing and editing custom macros
Copyright IBM Corporation 2015. All Rights Reserved.