Skip to Content
0

Recursive call of TF (TUDF, Table UDF) and / or SF (SUDF, Scalar UDF) possible

Nov 24, 2017 at 02:26 PM

80

avatar image

Is it possible to do recursion with

SF / Scalar User Defined Function / SUDF

and / or

TF / Table User Defined Function / TUDF

We have an SQL running on SQL Server an we need to implement it in HANA SQL.

When I try to implement recursion I get the activation error:

invalid name of function or procedure

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

2 Answers

Lars Breddemann
Nov 24, 2017 at 10:29 PM
0

Recursive constructs are not supported in general. That’s likely due to the limitations to multi-core/multi-node processing such constructs bring with them.

For specific scenarios, like procession hierarchy data stored in a table, HANA2 provides special functions).

Share
10 |10000 characters needed characters left characters exceeded
Thorsten Niehues Jan 17 at 10:49 AM
0

A recursive function can also be implemented as a iterative function.

Which is usually faster anyway.

So I implemented the recursive function in an iterative way

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sure - but that wasn’t what you asked, was it?

0