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
3 REPLIES
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