1.
|
2.
|
3.
|
From the Save Under drop-down list, select the folder location to which you want to save the custom macro.
|
4.
|
In the Name field, enter a name and declaration for the custom macro so that it can be referenced, using the following syntax:
|
![]() |
If a custom macro has the same name as a built-in macro, the custom macro will take precedence. As a best practice, to avoid confusion, do not name custom macros with operator names or names that are the same as those of built-in macros in Campaign. The exception would be if you specifically want the new custom macro to always be used, and the built-in macro to be inaccessible.
|
5.
|
6.
|
Optionally, use the Note field to enter any notes for the new custom macro, providing a clear explanation of what the custom macro is designed to do and what each variable represents.
|
7.
|
![]() |
If you select Raw SQL Selecting ID List, you must also select a database from the drop-down list in the Database field.
|
![]() |
If you select Raw SQL Selecting ID + Value, you must also select a database from the drop-down list in the Database field and select the value type of the field from the Value Type drop-down list. Ensure that the value type you select here is correct. Otherwise, when you later attempt to profile this query, you will get a "Mismatched Type" error.
|
![]() |
If you selected Text as the value type, specify the width of the value type in bytes in the Width (# Bytes) field. You must obtain this width in bytes information from the database. If you do not have access to the database or are unable to obtain the information, enter 256, the maximum width.
|
8.
|
10.
|
11.
|
Copyright IBM Corporation 2012. All Rights Reserved.
|