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

One Star

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

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
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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

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

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