---
parser: v2
author_name: Rich Heilman
author_profile: https://github.com/rich-heilman
primary_tag: products>sap-hana
tags: [  tutorial>intermediate, topic>sql, products>sap-hana, products>sap-hana\,-express-edition  ]
time: 10

slug: xsa-sqlscript-usingindexbased
canonical_url: https://developers.sap.com/tutorials/xsa-sqlscript-usingindexbased
---

# Using Index Based Cell Access
<!-- description --> Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries

## Prerequisites  
 - This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud.

## You will learn  
- How to use index-based cell access to manipulate table data.

## Intro
Using index-based cell access to manipulate table data is faster than using cursors or arrays.

---

### Create a New Procedure


Use what you have learned and create a new procedure called `build_products` in the procedure folder.

![procedure editor](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-sqlscript-usingindexbased/1.png)

Define an output parameters as show here.

![output parameter](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-sqlscript-usingindexbased/2.png)


### Insert Into Table


Using index based cell access, insert rows into an intermediate table variable as shown here.

![insert](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-sqlscript-usingindexbased/3.png)



### Check Complete Code


The completed code should look like the following.
```
PROCEDURE "build_products" (
	        out ex_products table (PRODUCTID nvarchar(10),
                               CATEGORY nvarchar(20),
                               PRICE decimal(15,2) ) )
   LANGUAGE SQLSCRIPT
   SQL SECURITY INVOKER
   READS SQL DATA AS
BEGIN

 declare lt_products table like :ex_products;

 lt_products = select PRODUCTID, CATEGORY, PRICE from "MD.Products";

 lt_products.productid[1] = 'ProductA';
 lt_products.category[1] = 'Software';
 lt_products.price[1] = '1999.99';

 lt_products.productid[2] = 'ProductB';
 lt_products.category[2] = 'Software';
 lt_products.price[2] = '2999.99';

 lt_products.productid[3] = 'ProductC';
 lt_products.category[3] = 'Software';
 lt_products.price[3] = '3999.99';

 ex_products = select * from :lt_products;

END
```



### Save and Build


Click **Save**.  Use what you have learned already and perform a build on your `hdb` module.

![save](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-sqlscript-usingindexbased/5.png)



### Run Call Statement Again


Return to the Database Explorer page and generate and run the CALL statement.

![HRTT](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-sqlscript-usingindexbased/6.png)



### Check the Results


Check the results.

![results](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/xsa-sqlscript-usingindexbased/7.png)