Example

If you want to create five tables (tab1, tab2, tab3, tab4, and tab5), you could create a transformation similar to this one:

Execute SQL Script Example

The SQL script to execute might look like this:

CREATE TABLE tab?
(
a INTEGER
);

The field name to specify as the parameter is then the "count" sequence defined in the second step.

Note: The execution of the transformation will halt when a statement in the script fails.

As an extra option, you can return the total number of inserts (INSERT INTO statements), updates (UPDATE table), deletes (DELETE FROM table) and reads (SELECT statements) by specifying the field names in the lower right of the dialog box.