Intermediate Table Variables
January 5, 2021
Intermediate
15 min.
Leveraging 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 on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.
- Tutorials: Parallel Processing and Parameters
Step 1: Edit Previous Procedure
Step 2: Define New Output Parameter
Step 3: Rename Variables
Step 4: Edit SELECT Statements
Step 5: Add SELECT Statement
Step 6: Check Complete Code
Step 7: Save and Build
Step 8: Run and View Results