ETL 4.9 includes a new transformation component, SQL Executor, which allows you to execute a custom SQL statement or multiple statements against a database server. SQL Executor is a standalone component without any input or output ports, and can be placed into a project that is separate from other components, or in a single project containing one or more SQL Executor components.
The SQL Executor component also allows you to load data from multiple input data streams into the Sybase IQ database in a single transaction, using multiple SQL statements. This leads to maximum flexibility for all ETL users.
Use the SQL Executor component to:
Allow other projects to read or write data into the same database.
Load data from a source table to an IQ supported text file format, using a SQL statement.
Load data from the text file into the target IQ database, in a single transaction, using the Load Table command.
The SQL Executor component comes with pre- and post-SQL statement parameters. It executes SQL script line-by-line, then checks whether the SQL script is syntactically correct at the target database. You can also define different custom SQL scripts to execute, if the script runs successfully or fails.
See Chapter 5, “Components” in the Sybase ETL 4.9 Users Guide.
