Code does not run / work with F5, but in HANA Studio

Toad for SAP Solutions
1

Hi,

this code

do begin
declare v_i integer;
for v_i in 1..12 do delete from SCHEMANAME.TABLENAME where PERDE = v_i;
commit;
end for;
end;

does not work / run in TOAD
error : SAP Hana Database Error: sql syntax error: line 2 col 13 (at pos 23)

when I copy this code 1:1 to HANA Studio and press F8 in HANA Studio it works.

Is there a option to run this code like in HANA Studio?

Holger

2

Hi, which version of HANA and Toad are you running?

3

Hi,

Toad is : 3.2.0.96 (64bit)
HANA is 1.00.12.23.....

Holger

4

That looks like a bug. I opened TMB-2230 so that we can fix it.
In the meanwhile you could try disabling "Perform automatic syntax checks" here:

image
image.png823×346 21.2 KB

5

Hi Dan,

same error

image
image.png778×139 11 KB

same error
image

on HANA Studio

image
image.png796×710 7.35 KB

Holger

6

Hello Holger,

HANA 1.0 SPS 12 that is?
Toad for SAP currently supports SPS 09 only, constrained by our parser component. However, the good news is that today we started work on upgrading to version 2.0 SPS 04. Anonymous blocks, such as the one you came up with, will be addressed as early as possible. Can't provide precise schedule, but one month from now will already show a substantially different picture.

Hope this helps,
Andre (parser lead)