Название: SQLScript for SAP HANA
Автор: Jorg Brandeis
Издательство: Rheinwerk Publishing, SAP Press
Год: 2019
Страниц: 439
Язык: английский
Формат: pdf (true)
Размер: 10.1 MB

Developers, your complete guide to SQL Script programming for SAP HANA is here! Get hands-on with the SQLScript language, understand the data types you'll work with, and master the function library. Learn to implement SAP HANA database procedures and functions using imperative and declarative SQL script. See how SQLScript plays with ABAP, SAP BW on SAP HANA, and SAP BW / 4HANA. Finally, optimize, troubleshoot and analyze your SQLScript programs. The SQLScript programming language is the associated "SQL dialect" that you can use to send queries to SAP HANA. This dialect has been part of SAP HANA from the very beginning.

* Learn SQLScript syntax and run your first routine in the SQL console
* Use SQLScript to read and write to the SAP HANA database
* Integrate SQLScript with ABAP and SAP BW/4HANA

SQL Language Elements
See how to develop simple SQL routines, and learn about the key elements of SQLScript, the data types of SAP HANA, and declarative and imperative programming.

SQL Function Library
Master the most important functions of the SAP HANA database, including aggregate functions, string functions, and type conversions.

SQLScript in SAP Applications
Learn how to integrate SQLScript procedures into ABAP, SAP BW on SAP HANA, or SAP BW/4HANA programs.

* SAP HANA Studio
* SAP Web IDE for SAP HANA
* SQL console
* Read and write database access
* Flow logic
* Tables and views
* Sequences and triggers
* ABAP managed database procedures (AMDP)
* SAP HANA development environment
* Optimization
* Troubleshooting and analysis