Create Scalar User Defined Functions
February 14, 2021
Intermediate
15 min.
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
You will learn
- How to create a scalar UDF for generating a full name from the last, first and middle name of the employee
Prerequisites
- This tutorial is designed for SAP HANA Cloud.
- Tutorials: Intermediate Table Variables
Step 1: Create new function
Step 2: Edit the function and save
Step 3: Edit the procedure and save
Step 4: Deploy and check results