Intermediate Table Variables
February 14, 2021
Intermediate
15 min.
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
You will learn
In this exercise you will modify the code of procedure get_po_header_data
again to use a single tabular output. Existing queries will be reused based on intermediate table variables.
Prerequisites
- This tutorial is designed for SAP HANA Cloud.
- Tutorials: Parallel Processing and Parameters
Step 1: Edit previous procedure
Step 2: Save, deploy, run and check results
Navigate tutorial steps