SQLScript for SAP HANA (Hardcover)

... Introduction ... 15 ... Structure of the Book ... 18 ... Acknowledgments ... 20 1 ... SAP HANA ... 23 1.1 ... What Is SAP HANA? ... 24 1.2 ... System Architecture ... 32 1.3 ... Organizing Database Objects ... 36 1.4 ... Development Environments ... 40 1.5 ... The SQL Console ... 50 2 ... Getting Started with SQLScript ... 55 2.1 ... SQL Versus SQLScript ... 56 2.2 ... Basic Language Elements ... 59 2.3 ... Modularization and Logical Containers ... 78 2.4 ... Sample Program ... 94 3 ... Declarative Programming in SQLScript ... 109 3.1 ... Table Variables ... 110 3.2 ... SELECT Statements ... 112 3.3 ... Other Operators ... 160 4 ... Data Types and Their Processing ... 165 4.1 ... Character Strings ... 166 4.2 ... Date and Time ... 185 4.3 ... Numerical Data ... 201 4.4 ... Binary Data Types ... 213 4.5 ... Conversions Between Data Types ... 218 5 ... Write Access to the Database ... 221 5.1 ... INSERT ... 222 5.2 ... UPDATE ... 226 5.3 ... UPSERT or REPLACE ... 227 5.4 ... MERGE INTO ... 229 5.5 ... DELETE ... 232 5.6 ... TRUNCATE TABLE ... 232 6 ... Imperative Programming ... 233 6.1 ... Variables ... 233 6.2 ... Flow Control Using IF and ELSE ... 249 6.3 ... Loops ... 253 6.4 ... Cursors ... 256 6.5 ... Arrays ... 260 6.6 ... Transaction Control ... 268 6.7 ... Executing Dynamic SQL ... 271 6.8 ... Error Handling ... 276 7 ... Creating, Deleting, and Editing Database Objects ... 283 7.1 ... Tables ... 284 7.2 ... Table Types ... 291 7.3 ... Views ... 291 7.4 ... Sequences ... 294 7.5 ... Triggers ... 296 8 ... SQLScript in ABAP Programs ... 301 8.1 ... AMDP Procedures ... 304 8.2 ... CDS Table Functions ... 319 8.3 ... AMDP Functions for AMDP Methods ... 327 8.4 ... Alternatives to AMDPs for Calling SQLScript Code from ABAP Programs ... 329 8.5 ... Recommendations ... 330 9 ... SQLScript in SAP Business Warehouse ... 333 9.1 ... Transformation Routines as AMDP ... 338 9.2 ... Successive Transformations and Mixed Execution ... 339 9.3 ... The Generated AMDP Classes ... 341 9.4 ... The Individual Routines ... 348 9.5 ... Error Processing and Error Stack ... 352 10 ... Clean SQLScript Code ... 357 10.1 ... The Readability of the Code ... 358 10.2 ... Performance Recommendations ... 373 11 ... Tests, Errors, and Performance Analysis ... 375 11.1 ... Testing SQLScript Code ... 376 11.2 ... The Debugger for SQLScript ... 381 11.3 ... Performance Analysis ... 397 ... Appendices ... 417 A ... Data Model for Task Management ... 419 B ... List of Abbreviations ... 423 C ... The Author ... 425 ... Index ... 427