Intermediate
Using Index Based Cell Access
January 5, 2021
10 min.
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
You will learn
- How to use index-based cell access to manipulate table data.
Prerequisites
- This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.
Using index-based cell access to manipulate table data is faster than using cursors or arrays.
Step 1: Create a New Procedure
Step 2: Insert Into Table
Step 3: Check Complete Code
Step 4: Save and Build
Step 5: Run Call Statement Again
Step 6: Check the Results