The 2nd edition of the English edition of SQLScript for SAP HANA is scheduled for release on August 26, 2021. The issue is updated and expanded with a few new topics. It thus largely corresponds to the current German edition.
- SQLScript Unit Tests, the End-User Test Framework
- Parallel processing with MAP_MERGE
- User Defined Libraries (UDL) in SQLScript
- Recursive procedure calls in SQLScript
- Embedded (or anonymous) functions in SQLScript
- DML table variables
Other topics include:
- Lateral Join – The term lateral join is somewhat misleading, as it is not another type of join, such as inner join or left outer join. Rather, a lateral join is a join where the join partner is a correlated subquery or function. You can think of a lateral join as executing the subquery separately for each row of the previous result. It is possible to access the data of the current row by the correlation name.
- The SQLSCRIPT_STRING library provides additional functions for processing character strings:
SPLITyou can split a string of separators into several small sections
FORMATyou can format a string with a syntax from the Python language
- And with
TABLE_SUMMARYyou can make a string out of a table
- With ABAP BASIS 7.53, scalar AMDP functions are possible. This is very important, especially for BW/4HANA routine development, since this was not possible until now.
- Data series can be generated with the SERIES_GENERATE functions. This is especially handy for date values.
And, of course, there are countless other minor additions and corrections. For example, many screenshots of the BW interfaces in the SAP GUI were replaced by the new BW/4HANA interfaces in Eclipse.
This post is also available in: Deutsch