[Squirrel-sql-users] using anonymous procedures

[Bram G. <gad...@gm...>]

Hi,

Is there an option in Squirrel so that it would ignore the statement
separator ; for code that is between “begin” and “end” statements?

I’d like to execute something like this code below against a Teiid JDBC
connection but it fails.

begin
create local temporary table tmp_curresult(
res integer
);
LOOP ON (SELECT 1 as col1 union select 2) AS cur1
BEGIN
insert into tmp_curresult(res)
values(cur1.col1);
END
select * from tmp_curresult;
end;

I can see that squirrel only sends this part at first:

  begin
create local temporary table tmp_curresult(
res integer
)

With kind regards

-- 
Bram Gadeyne