Skip to Content
avatar image
Former Member

Can't create HANA Scalar User Defined Function

I have this simple function, I get the usual not recommended to create a scalar UDF. In the SAP Hana Administration console it's created the UDF anyway. If I try to create the UDF from HanaCommand with ExecuteNonQuery it does not create the UDF. I've looked everywhere and I haven't found any way to pass through this.

I need help ASAP, as if this is not fixed I will have to tell the client's to manually install the AddOn because of the way SAP HANA is limited.

CREATE FUNCTION "Total"(DocEntry int) returns retVal decimal(19,6) LANGUAGE SQLSCRIPT SQL SECURITY INVOKER AS Begin select IFNULL(SUM("Price"*"LineTotal"), 0) into retVal from RDR1 where "DocEntry" = :DocEntry; End;

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 23, 2016 at 09:57 PM

    Hi Youval,

    First things first: please bear in mind that this is not a 24x7 support channel. It's a public community and not suitable for critical cases (if that's your scenario). If you need urgent/critical support you can use SAP support.

    Now for your technical issue: you did not specify completely how you're reaching the issue here (nor its details). I'm guessing you tried to create a function over an ODBC ExecuteNonQuery method. Can you share your sample code and steps to reproduce that issue?

    Best Regards,

    Lucas de Oliveira - Moderator

    Add comment
    10|10000 characters needed characters exceeded