Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 24, 2017 at 10:29 PM

    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).

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 17 at 10:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded