Hi,

I am new to Talend and maybe I have missed something (I Hope) that will allow me to execute SQL statements stored in a file.  Specifically I have a DDL script that I want to run to create all of the data structures -- Types, Tables, Indexes, Constraints, FK, etc prior to doing the data load steps.  Is there a simple way to do this?  I am currently trying to do this against a DB2 database but will want this to be database agnostic.  I would prefer to do this all within Talend as part of a job rather than use a separate tool to do the ddl and then talend for the dataload.

The data in the flat file generated by ER/Studio I want to load looks something like this (times hundreds of tables):


CREATE DISTINCT TYPE ADDRESSGENERAL AS VARCHAR(40) WITH COMPARISONS
;

CREATE DISTINCT TYPE BITMAP AS CHAR(128) WITH COMPARISONS
;

We are using TOS2.2.1


Thanks in advance for any direction you can give me on this.