Creating Table User Defined Functions
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
You will learn
- How to transform a procedure to a table function.
Prerequisites
- This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.
- Tutorials: Creating Scalar User Defined Functions
There are application and scenarios where you need a table function instead of procedure to leverage the advantage of direct selects on the output, for example, filtering, sorting and grouping. In the following exercise, we show you how you can easily transform a procedure to a table function.