The 2nd edition of SQLScript for SAP HANA will be published in August

Veröffentlicht am 19. Juli 2021 von

Jörg Brandeis

| AMDP | News | SAP HANA | SQLScript |

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.

New topics

SQLScript for SAP HANA 2nd 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:
  • With SPLIT you can split a string of separators into several small sections
  • With FORMAT you can format a string with a syntax from the Python language
  • And with TABLE_SUMMARY you 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.