Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

For All Entries - implementation in HANA database

suwandi_cahyadi
Contributor

‎2020 Mar 30 12:36 PM

0 Kudos
195

Hi,

From this document, seems like for Ms SQL server the implementation of For All Entries is converted to SQL syntax with UNION. That's why I remember some time I encounter an error saying the SQL statement length exceeded maximum. In case of HANA, how is For All Entries converted to the SQL syntax? I remember trying For All Entries with tens thousand of records but still no dump/error saying the SQL statement length exceeded maximum.

Thank you.

1 REPLY 1

Sandra_Rossi
Active Contributor

‎2020 Mar 30 1:25 PM

0 Kudos
99

Do a SQL trace (ST05 on all servers) and you'll know how it's converted.

It has always been possible for all databases to get the error "SQL statement length exceeded maximum", it depends on the limit of the database system, on the number of lines of the internal table, on the number of logical expressions in the WHERE clause, etc.