Cacher is the code snippet organizer for pro developers

It is the language to write stored procedures and user defined functions in SAP HANA It is an extension of ANSI SQL

Goal:

Eliminate data transfer between database & application layers Calculations are executed at database layer instead of the application layer to get benefits of HANA database - like column operations, parallel processing of queries, etc. Only the result set will be sent to the application layer Mass transfer between database & application layer is reduced drastically, which is beneficial to performance

Advantages of SQL Scripting:

Modular programming (You can split one big SQL statement into multiple statements and you can store intermediate results in local variables. You can work on the local variables and adapt them further to optimize your result set.) Local variables for intermediate results Supports parameters (you can pass these parameters to a stored procedure or function -> you can dynamically control filters by using parameters, like variables) Parameters give you the flexibility to run your script Flow control logic (IF-Then-Else) Loops (While, for) Stored procedure can return multiple results, an SQL statement only returns one result set

HANA also supports LSCRIPT and RSCRIPT