cancel
Showing results for 
Search instead for 
Did you mean: 

Can't create HANA Scalar User Defined Function

Former Member
0 Kudos

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;

Accepted Solutions (0)

Answers (1)

Answers (1)

lucas_oliveira
Advisor
Advisor

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