Specifying pre- or post-processing SQL statements
If you are using a Select or Extract process, you can optionally include raw SQL statements to run before or after the process:
*
Pre-processing: Enter raw SQL to be processed before the query runs
*
Post-processing: Enter raw SQL to be processed after the query runs
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
*
For important information, see Creating queries using SQL. If you are using in-database optimization, see Improving flowchart performance using in-database optimization
To specify pre- or post-processing SQL statements
Copyright IBM Corporation 2015. All Rights Reserved.