topic Re: Database initialization with SQL as variables in Talend Studio

Database initialization with SQL as variables

Anonymous — Sat, 16 Nov 2024 07:38:00 GMT

Hi,

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...

Thanks for your help

Re: Database initialization with SQL as variables

Anonymous — Wed, 19 Sep 2018 13:39:05 GMT

Hi,

Could you please provide a screen shot for better understanding of your query?

Warm Regards,

Nikhil Thampi

Re: Database initialization with SQL as variables

Anonymous — Wed, 19 Sep 2018 15:08:37 GMT

Here are screenshots

sql2.png
sql1.png

Re: Database initialization with SQL as variables

Anonymous — Wed, 19 Sep 2018 15:35:13 GMT

Can you replace your "create stop times" component with a tLogRow? Then run the job. Can you also show us your tFixedFlowInput schema?