topic Re: How to run multiple queries (with temp table queries) in Netezza in Talend Studio

How to run multiple queries (with temp table queries) in Netezza

_AnonymousUser — Thu, 12 Dec 2013 09:38:46 GMT

Hi All,
Am having Two Queries,
1. First query will create a temp table with set of data from final table.
2. Second query will insert data into final tables from the temp table.

Example:
Query 1: CREATE temp TABLE TABLE_A AS ( SELECT * FROM TABLE_B);
Query 2: INSERT INTO FINAL_TABLE(select * FROM from TABLE_A);
While fetch data from temp table (i.e, TABLE_A), data is not inserting into FINAL_TABLE.
I tried with tNetezzaRow, but data is not inserting into tables.
Please help me to resolve the above issue.

Thanks,
Divakar

Re: How to run multiple queries (with temp table queries) in Netezza

Anonymous — Thu, 12 Dec 2013 10:49:49 GMT

Hi,
Did you update Additional JDBC Parameters" to include "allowMultiQueries=true" in Advanced Setting of tNetezzaRow?
Here is a related article on Talend Help Center Executing multiple SQL statements with one tMysqlRow component.
Best regards
Sabrina

Re: How to run multiple queries (with temp table queries) in Netezza

_AnonymousUser — Thu, 12 Dec 2013 11:44:33 GMT

Hi,
I tried with "allowMultiQueries=true" in tNetezzaRow, still temp table data is not inserting into final table.
Thanks,
Divakar. N

Re: How to run multiple queries (with temp table queries) in Netezza

Anonymous — Sat, 30 Jan 2016 07:47:28 GMT

Hi,
Did you update Additional JDBC Parameters" to include "allowMultiQueries=true" in Advanced Setting of tNetezzaRow?
Here is a related article on Talend Help Center Executing+multiple+SQL+statements+with+one+tMysqlRow+component.
Best regards
Sabrina

Dear sabrina,
I want to implement
Insert into table
(col1,
col2
...
con n)
Sel
col1,
col2,
...
con n
from table_name;
i want to implement above in talend
how will i achive it>
can someone give me steps to do so
help will be appretiated.
thanks,
Amit