SQLScript for SAP HANA
(Sprache: Englisch)
Developers, your complete guide to SQLScript 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...
Leider schon ausverkauft
versandkostenfrei
Buch (Gebunden)
78.50 €
- Lastschrift, Kreditkarte, Paypal, Rechnung
- Kostenlose Rücksendung
- Ratenzahlung möglich
Produktdetails
Produktinformationen zu „SQLScript for SAP HANA “
Klappentext zu „SQLScript for SAP HANA “
Developers, your complete guide to SQLScript 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 SQLScript. See how SQLScript plays with ABAP, SAP BW on SAP HANA, and SAP BW/4HANA. Finally, optimize, troubleshoot, and analyze your SQLScript programs. a. 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.
b. SQL Function Library
Master the most important functions of the SAP HANA database, including aggregate functions, string functions, and type conversions.
c. SQLScript in SAP Applications
Learn how to integrate SQLScript procedures into ABAP, SAP BW on SAP HANA, or SAP BW/4HANA programs.
1) SAP HANA Studio
2) SAP Web IDE for SAP HANA
3) SQL console
4) Read and write database access
5) Flow logic
6) Tables and views
7) Sequences and triggers
8) ABAP managed database procedures (AMDP)
9) SAP HANA development environment
10) Optimization
11) Troubleshooting and analysis
Inhaltsverzeichnis zu „SQLScript for SAP HANA “
... 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 ...
... mehr
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
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
... weniger
Autoren-Porträt von Jörg Brandeis
Jörg Brandeis is an independent consultant and developer with a focus on SAP BW for HANA and SAP BW/4HANA. Until mid-2015 he was a development manager for ABAP at zetVisions AG in Heidelberg. He developed and conducted a workshop on SAP HANA development and SQLScript and is experienced in training ABAP developers to use SQLScript.
Bibliographische Angaben
- Autor: Jörg Brandeis
- 2019, 435 Seiten, Maße: 17,9 x 23,6 cm, Gebunden, Englisch
- Verlag: SAP Press
- ISBN-10: 1493218220
- ISBN-13: 9781493218226
- Erscheinungsdatum: 23.05.2019
Sprache:
Englisch
Kommentar zu "SQLScript for SAP HANA"
Schreiben Sie einen Kommentar zu "SQLScript for SAP HANA".
Kommentar verfassen