Multiple SQL statement in one component

[Karuetl]

How to execute multiple sql statements in one component .. Please let me know 

I am using Snowflake DB

[Anonymous]

Hello,

Do you want to use multiple sql statement in sql query field of tSnowFlakeInput component?

Have you already checked 'Manual query' check box and entered within double quotation marks in the Full SQL query string field?

Best regards

Sabrina

[Karuetl]

I am using Talend 6.2.1 version i dont see tSnowflake component So i am using tJDBC component

[Anonymous]

Hello,

Here exists a new feature jira issue about 'Integrate SnowFlake Components'

https://jira.talendforge.org/browse/TDI-38068

This issue has been fixed on V 6.4.1.

For tJDBCROW component, maybe you can add commit keyword in your query.

"Begin

UPDAT.....;

UPDAT.....
Delete from.....;
commit;

end;"

Best regards

Sabrina

[Karuetl]

Got below error 

"

Multiple SQL statements in a single API call are not supported; use one API call per statement instead.

end;
"

[manodwhb]

creat a store procedure for those multiple sql's and use tJDBCSP comonent to execute that store procedure.

[manodwhb]

did my solution help you?

[Karuetl · Accepted solution]

I used tFileDelimited component and in the text file i had all the SQL statement 

[Anonymous]

---

@Karuetlwrote:

I used tFileDelimited component and in the text file i had all the SQL statement 

---

Hi,

Can you please give more detail as to how you did this?  I have exactly the same requirement.

Kind regards

Marius

[Anonymous]

Is this issue fixed? I have the same scenario. It's not working. could you pls mark this topic as not solved, we are giving the wrong message to the community group