HANA sql condition conversion

Answered

Comments

1 comment

  • Official comment
    Avatar
    Yaremi Miranda Lopez

    Hello Lorenzo,

    I'm no HANA expert but I seem to me that the problem is the variable. I created a query in my system and here is the result in SQL and after converting it using the SQL HANA conversion tool by Boyum IT. It should work.

     

     

     

     

    SELECT CASE
    WHEN ((SELECT T0."ActType" FROM "OACT" T0 WHERE T0."AcctCode" = $[$76.1.0]) = 'E')
    THEN
    (
    SELECT 'BOYUM' FROM DUMMY
    )
    END FROM Dummy

    Comment actions Permalink

Please sign in to leave a comment.