topic Re: Multiple SQL statement in one component in Talend Studio

Multiple SQL statement in one component

Karuetl — Tue, 30 Jan 2018 17:39:10 GMT

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

I am using Snowflake DB

Re: Multiple SQL statement in one component

Anonymous — Wed, 31 Jan 2018 07:37:39 GMT

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

Re: Multiple SQL statement in one component

Karuetl — Wed, 31 Jan 2018 12:54:05 GMT

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

Re: Multiple SQL statement in one component

Anonymous — Thu, 01 Feb 2018 08:31:59 GMT

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

Re: Multiple SQL statement in one component

Karuetl — Thu, 01 Feb 2018 13:44:24 GMT

Got below error

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

end;
"

Re: Multiple SQL statement in one component

manodwhb — Fri, 02 Feb 2018 06:16:49 GMT

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

Re: Multiple SQL statement in one component

manodwhb — Tue, 20 Feb 2018 10:48:18 GMT

did my solution help you?

Re: Multiple SQL statement in one component

Karuetl — Tue, 20 Feb 2018 14:07:43 GMT

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

Re: Multiple SQL statement in one component

Anonymous — Wed, 02 May 2018 04:49:31 GMT

@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

Re: Multiple SQL statement in one component

Anonymous — Tue, 09 Oct 2018 23:41:00 GMT

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

Re: Multiple SQL statement in one component

Anonymous — Tue, 09 Oct 2018 23:42:42 GMT

it's not working, we tried using begin .... end; too.

Re: Multiple SQL statement in one component

tomwattsusa — Thu, 20 Jan 2022 22:54:37 GMT

For Talend tDBRow, running multiple statements for Snowflake, I can run multiple statements by using a begin and end statment:

begin

create or replace table tom(first_name varchar(100));

insert into tom(first_name) values('Tommy');

end;

Re: Multiple SQL statement in one component

Rama4 — Wed, 06 Jul 2022 23:36:59 GMT

in which version of talend multiple statements are working ?

I am not able to execute multiple statement in tsnowflake input component , I am using Talend 7.3.1

Re: Multiple SQL statement in one component

Anonymous — Thu, 07 Jul 2022 04:31:51 GMT

Hello,

What's error message are you getting? Could you please show us your multiple statements? Does it work well in tSnowFlakeRow component?

Best regards

Sabrina

Re: Multiple SQL statement in one component

Rama4 — Thu, 07 Jul 2022 23:12:36 GMT

I am using tDBRow(Snowflake) component, it is working now if we use begin and end statements

Re: Multiple SQL statement in one component

Anonymous — Mon, 11 Jul 2022 02:39:01 GMT

Hello,

Is this solution using tDBRow(Snowflake) with begin and end statements fine with you?

Is there any specific requirement for you to use multiple statements in tSnowFlakeInput component?

Best regards

Sabrina