---
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-cloud, products>sap-business-application-studio]
time: 10

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

# Use Index-Based Cell Access 
<!-- description --> Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.

## Prerequisites  
- This tutorial is designed for SAP HANA Cloud.
- **Tutorials:** [Debugging Stored Procedures](hana-cloud-sqlscript-debugging)

## 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


1. 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/hana-cloud-sqlscript-usingindexbased/1_1.png)

2. Use what you have learned about procedure parameters, and define an output parameters as show here.

   ```SQLCRIPT
   out ex_products table (PRODUCTID nvarchar(10),
                          CATEGORY nvarchar(40),
                          PRICE decimal(15,2))
   ```


### Insert procedure code


1. Between the BEGIN and END statements, using index based cell access, insert rows into an intermediate table variable using the following code.

   ```SQLCRIPT

    declare lt_products table like :ex_products;

    lt_products = select PRODUCTID, CATEGORY, PRICE from "OPENSAP_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;

   ```

2. The completed code should look like the following.

   ```SQLCRIPT
     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 "OPENSAP_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, deploy and check results


1. **Save** the procedure

    ![save](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-usingindexbased/3_1.png)

2. Perform a **Deploy**

    ![save](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-usingindexbased/3_2.png)

3. Return to the Database Explorer page and generate and run the CALL statement for this procedure.

    ![DBX](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-usingindexbased/3_3.png)

4. Run the procedure and check the results.

    ![results](https://raw.githubusercontent.com/sap-tutorials/Tutorials/master/tutorials/hana-cloud-sqlscript-usingindexbased/3_4.png)