Building raw SQL statements in Campaign
If you are creating a query in a process box, you can click Advanced in the query window to access advanced settings. The available features depend on which process you are configuring.
For example, in the Select process, you can use raw SQL to create a query and you can run pre- and post-processing SQL commands.
The Advanced Settings window includes two panes:
*
Pre-processing: Enter raw SQL to be processed before the query runs
*
Post-processing: Enter raw SQL to be processed after the query runs
The SQL statements run in the order in which they are listed.
Use this feature to include SQL procedures as part of the process run, which can be useful for ETL, routine data mart updates, performance tuning, and security. For example, you can use pre- and post-processing SQL statements to:
*
Run stored procedures in the database
*
Create, drop, and re-create 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
Pre- and post-processing statements can be used with either raw SQL or standard processing in the Select process query.
*
For important information about using raw SQL queries with in-database processing, see Choosing in-database processing for processes and Using the TempTable and OutputTempTable tokens in raw SQL queries.
Copyright IBM Corporation 2013. All Rights Reserved.