finelybook
SQLScript for SAP HANA (Second Edition) (SAP PRESS)
Author: Jörg Brandeis
Publisher Finelybook 出版社: SAP Press; Second edition (August 24, 2021)
Language 语言: English
pages 页数: 409 pages
ISBN-10 书号: 1493221396
ISBN-13 书号: 9781493221394
Book Description
New to SQLScript―or maybe looking to brush up on a specific task? Whatever your skill level, this comprehensive guide to SQLScript for SAP HANA is for you! Master language elements, data types, and the function library. Learn to implement SAP HANA database procedures and functions using imperative and declarative SQLScript. Integrate with ABAP, SAP BW on SAP HANA, and SAP BW/4HANA. Finally, test, troubleshoot, and analyze your SQLScript programs. Code like the pros!
Learn SQLScript syntax and run your first routine in the SQL console
Read and write to the SAP HANA database
Integrate SQLScript with ABAP, SAP BW powered Author: SAP HANA, and SAP BW/4HANA
Language Elements
Learn about the key elements of SQLScript, from NULL values to the inner workings of SELECT statements. Walk though both declarative and imperative programming in SQLScript.
Database Elements
Change the contents of database tables using SQL statements. Learn how to create tables and other database objects directly, and delete and edit them as needed.
SQLScript in Practice
Work with detailed code examples to see concepts in action as they are introduced. Get insight into SQLScript with hundreds of line of code that have been tested in a live SAP HANA system.
SAP HANA Studio
SAP HANA Web-Based Development Workbench
SAP Web IDE
SQL console
Language basics
Declarative and imperative programming
Data types
Database programming
ABAP-managed database procedures (AMDP)
SAP BW and SAP BW/4HANA
Clean code
Troubleshooting and analysis
