1.
|
2.
|
To enter a pre-processing raw SQL statement, double-click inside the Pre-Processing field and enter the SQL statement you want to run before the process runs.
|
3.
|
Next, click in the Database field on that line, and select the name of the database on which you want to run this statement.
|
|
The Database drop-down list displays all of the available databases (those for which a data source category has been configured on the Configuration page in Marketing Platform). If your database does not appear in this drop-down list, contact your Campaign system administrator.
|
4.
|
Click to select the SQL check box if you want to view only SQL functions in the list pane. Click again to clear and see the full list of available functions and operators.
|
|
If you already enabled the Use Raw SQL option on the Advanced Settings window, the SQL option in the Query Helper is enabled. This will hide Campaign macro functions, so that only SQL operators and functions are displayed.
|
Copyright IBM Corporation 2013. All Rights Reserved.
|