The SAP HANA SQLscript
In the following section, we will learn about the SAP HANA SQLscript and see the additional capabilities it brings along with it.
Why SQLscript?
SQLscript is a collection of extensions in Structured Query Language (SQL). The main motivation for SQLscript is to push data intensive application logic into the database, which was not being done in the classical approach where the application logic is mostly executed in an application layer.
We have the following extensions for SQLscript:
|
Extension |
Usage |
|---|---|
|
Datatype extension (create/drop type) |
This allows definition of table type without corresponding tables |
|
Procedural extension (create procedure) |
This is an imperative construct to push data intensive logic into the ... |
Get Real Time Analytics with SAP HANA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
