Skip to Content

Can't create HANA Scalar User Defined Function

Nov 22, 2016 at 08:47 PM


avatar image
Former Member

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;

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member
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

10 |10000 characters needed characters left characters exceeded