To specify pre- or post-processing SQL statements
1.
Begin configuring a Select or Extract process.
You can select all records or use a query to select specific IDs. For the Select process, you can apply pre or post processing regardless of the query type (standard query or Use Raw SQL for Record Selection).
2.
Click the Advanced button.
The Advanced Settings window appears.
3.
Double-click in the Pre-Processing area and enter a raw SQL statement to run before the process.
4.
Click in the Database cell, and select the database on which you want to run this statement.
The Database list shows all available databases (those for which a data source category was configured on the Configuration page in Marketing Platform). If your database does not appear in the list, contact your Campaign system administrator. You must enter a SQL statement before you can select a database.
The SQL statements are processed in the order in which they appear.
5.
Follow the same procedure to enter any Post-Processing SQL statements to run after the process.
The SQL statements are processed in the order in which they appear.
*
For information about the Use Raw SQL for record selection option in the Advanced Settings dialog, see To create a raw SQL query.
Copyright IBM Corporation 2015. All Rights Reserved.