I want to create a database from CSV files. I choosed a H2 database and wish to generate the database structure. I tried several ways but none worked.
The last one is this one:
- tFixedFlowInput with many SQL (drop table if exists, create table, drop index if exists, create index)
- tFixedFlowInput -> tDBRow with SQL as flow variable
While executing, the SQL is NULL. I thought that it should be defined at initialization cycle and broke the flow into two subjobs (tFixedFlowInput->tFlowToIterate->iterate->tFixedFlowInput->tDBRow) but with no better luck.
Is it a bug of tDBRow ? or should I do it by another way ? I want as less components as possible to do that...
