SAP HANA SQL script - IF ... SELECT statement

[Former Member]

Hi All,

I'd like to make SQL script for SAP HANA

is it possible IF statement followed by select statement ? like this ?

IF (SELECT (:posisi - 1) / 3.0 FROM DUMMY) = 1)

But when I tried, it shows error like this, is there any ways  I want IF statement with the value check from table ?

Regards,

Hendra

[Former Member]

Hi Hendra,

You can try the following

create  procedure "LabExercise".first_procedure1(in posisi int)

as

begin

declare number decimal(10,3);

SELECT (:posisi - 1) / 3.0 into number FROM DUMMY ;

IF number = 1 then

----------

---------

end if;

end;

Regards

Khaga