Skip to Content
0

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

Nov 23, 2016 at 08:20 AM

796

avatar image
Former Member

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

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

4 Answers

Shanthi Bhaskar Nov 23, 2016 at 01:51 PM
0
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 24, 2016 at 07:45 AM
0

@Bhaskar

Thanks for the link.

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

Share
10 |10000 characters needed characters left characters exceeded
Martin Sautter Mar 27 at 07:59 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 27 at 08:28 AM
0

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/

Share
10 |10000 characters needed characters left characters exceeded