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]

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

[tomwattsusa]

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;

"

[Rama4]

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

[Anonymous]

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

[Rama4]

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

[Anonymous]

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