Building raw SQL statements in Campaign
In processes which require queries, click Advanced on the query editing window to access the Advanced Settings features. The actual features will vary among processes.
For example, in the Select process, you can use the Advanced Settings to create a query using raw SQL or to execute pre- and/or post-processing SQL commands.
The Advanced Settings window includes two panes:
*
Pre-processing — enter raw SQL to be processed before the query executes
*
Post-processing — enter raw SQL to be processed after the query executes
This feature allows you to incorporate SQL procedures as part of the process run, and is useful in employing Campaign in efforts including ETL, routine mart updates, in-line performance tuning, and security functions.
You can use pre- and post-processing SQL statements in Advanced Settings to:
*
Run stored procedures in the database
*
Create, drop, and recreate tables and indexes
*
Grant or change privileges to other users or groups
*
Organize multi-step database commands
*
Run complex database routines, without having to use external scripts to connect to the database
The SQL statements are run in the order in which they appear.
*
Pre-Processing SQL statements are run before the query executes.
*
Post-Processing SQL statements are run after the query executes.
They can be used with either raw SQL or standard processing in the Select process query.
Raw SQL queries and in-database processing
For details about in-database processing with raw SQL queries, see Choosing in-database processing for processes.
Copyright IBM Corporation 2013. All Rights Reserved.