Introduction Structure of the Book Acknowledgments SAP HANA What Is SAP HANA? System Architecture Organizing Database Objects Development Environments The SQL Console Getting Started with SQLScript SQL Versus SQLScript Basic Language Elements Modularization and Logical Containers Sample Program Declarative Programming in SQLScript Table Variables SELECT Statements Other Operators Data Types and Their Processing Character Strings Date and Time Numerical Data Binary Data Types Conversions Between Data Types Write Access to the Database INSERT UPDATE UPSERT or REPLACE MERGE INTO DELETE TRUNCATE TABLE Imperative Programming Variables Flow Control Using IF and ELSE Loops Cursors Arrays Transaction Control Executing Dynamic SQL Error Handling Creating, Deleting, and Editing Database Objects Tables Table Types Views Sequences Triggers SQLScript in ABAP Programs AMDP Procedures CDS Table Functions AMDP Functions for AMDP Methods Alternatives to AMDPs for Calling SQLScript Code from ABAP Programs Recommendations SQLScript in SAP Business Warehouse Transformation Routines as AMDP Successive Transformations and Mixed Execution The Generated AMDP Classes The Individual Routines Error Processing and Error Stack Clean SQLScript Code The Readability of the Code Performance Recommendations Tests, Errors, and Performance Analysis Testing SQLScript Code The Debugger for SQLScript Performance Analysis Appendices Data Model for Task Management List of Abbreviations The Author Index.
SQLScript for SAP HANA