SQL Script is a collection of extensions to the Structured Query Language (SQL).

An SQL script can contain one or more SQL statements or PL/SQL blocks.

Data transfer between database and application layer can be eliminated using SQL Script. Calculations can be executed in the database layer using SQL Script to obtain maximum benefit out of SAP HANA database.

This is the sole language used for writing Stored Procedures in the HANA Database.

Data Manipulation Language (DML) SELECT, INSERT, UPDATE
Data Definition Language (DDL) CREATE , ALTER DROP
Data Control Language (DCL) GRANT ,REVOKE

Schema —  Organizing our development table, procedures in one particular space. It can be created in HANA by going to the modeller prespective and then right click on the catalog choose the SQL console and write the below Query.

Then we need to create a table inside this schema

The same can be done via SQL console as well

The final table will look something like this

Since we mentioned it as a column store table in the schema

We can even alter the table ac.dd new fields , changed table types etc

Let’s add some data in the tables we have created through the SQL Console

You can create a row store and a column store table and even you can convert a column store to row store or vice-versa

Alter table <schema_name>. <table_name> alter type column;

Before you can you the stored procedures you need to create a table type whivh will hold the structure of the data that you are giving as an output

SQL Script is the only language used for creating Stored Procedures. A procedure is a unit/block of related code that performs a certain task.SAP HANA procedures help us to put data-intensive complex logic into the database

To use these procedures in our ECC we need to use Database procedure proxies

GO to Other ->search of procedures you will find the proxy under the ABAP section give

the names as given below and click on next