Skip to Content

What exactly the difference between table function and procedures in SAP HANA

Hi Gurus,

Table functions and Stores Procedures.

on what basis we use them??

I came to know that to read the data we use table function we can't use and DDL and DML manipulations in table function.When comes to stored procedure we can read as well as manipulate.

Please explan me.

Kind Regards,

Nag

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 23, 2016 at 01:51 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 24, 2016 at 07:45 AM

    @Bhaskar

    Thanks for the link.

    still bit confused after reading it!! any specific difference other than which i mentioned?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 27 at 07:59 AM

    Hi

    a table function has a return value (skalar or table).

    A procedure ha an input / output list.

    In meta -syntax:

    in1 := ...

    in2 := ...

    in3 := ...

    myReturnValueOfMyTableFunction:= MyTableFunction ( in1, in2, in3,....)

    myReturnSkalarOfMyTableFunction := MyTableFunction ( in1, in2, in3, )

    ...

    MyProcedure ( in1, in2, in3, out1, out2 )

    ...:= out2.

    The wording table function is a bit confusing.

    Best
    Martin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 27 at 08:28 AM

    Major differences, I am not taking a deep dive...

    Table Function

    1) once you create the table function it can be used in SAP HANA view, procedure etc...

    2) It performs on HANA Engine that mean it will have multiple process.

    3) you can modify the Table function.

    Procedure

    You cant modify the procedure.

    Procedure runs on SQL engine, no multiple process

    Well i just found the link...

    https://blogs.sap.com/2016/09/07/table-functions-in-sap-hana-demo/

    Add comment
    10|10000 characters needed characters exceeded