Declare Variables in SAP HANA Studio

[Former Member]

Hi All,

I need to port a MS SQL Script in SAP Hana.

Usually in MSSQL Server I write something like:

DECLARE @CardName AS nvarchar(max)
SELECT @CardName = CardName FROM OCRD WHERE CardCode = 'C20000'
PRINT @CardName
...

How do I write an equivalent script in SAP Hana Studio?

Thank You,

paolo

[pedro_magueija]

Hi Paolo,

Best I could come to was:

SET 'MY_VAR' = 'C20000';

SELECT * FROM "OCRD" WHERE "CardCode" = (SELECT SESSION_CONTEXT('MY_VAR') FROM DUMMY);

UNSET 'MY_VAR'

It is not pretty, but until we find a better way...

Cheers.

---

Best regards,

Pedro Magueija

[former_member1139395]

This message was moderated.

[former_member383678]

Hi Paolo,

Here is an example procedure with your query:

create procedure test

language SQLSCRIPT AS

  CardName varchar(100);

begin

  select o.CardName into CardName from OCRD o  WHERE CardCode = 'C20000' ;

  select :CardName as "CardName" from DUMMY;

end

Regards,

dani

[Former Member]

Thank You Yordan,

you are creating a procedure here. I would like to obtain the same result WITHOUT the stored procedure.

When I connect using a DbConnector I would like to be able to run such command (or even more complex) without the need of creating a stored procedure just for that.

Thank You.

paolo

[Former Member]

Paolo,

I'm trying to do the same thing as you.   Did you find out how to declare variables in a sqlscript?

Thanks,

Chris

[Former Member]

Hi Chris,

not so far unfortunately ☹

[Former Member]

The documentarian on writing code in HANA seems a bit incomplete!

[Former Member]

I agree with you.

Any hint from SAP side?

Thank You,

paolo