Skip to Content
0

Similar to ABAP, how to create an internal table & append contents to it using HANA SQLSCRIPT ?

Aug 17, 2017 at 02:31 PM

101

avatar image
Former Member

Hi I want to create an internal table and insert/append content into it. But all this needs to be done in HANA Procedure using SQL SCRIPT.

Can anyone help me regarding this.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Lars Breddemann
Aug 20, 2017 at 10:33 PM
0

From your requirement "...this needs to be done in HANA Procedure using SQL Script..." I take it that performance is a major concern for your development.

If so, using an "internal table" like in ABAP is very likely the worst way to achieve that. "INSERT/APPEND" operations in an ABAP like style means imperative data processing and even worse one-by-one (slow-by-slow as Tom Kyte used to call it) processing.

That's not what you want for a high performing program.

While it is technically possible (check the SQL Script Reference documentation on that), it is very likely the wrong way to solve whatever problem you want to solve and a clear sign, that you're an ABAP developer writing SQL Script.

Share
10 |10000 characters needed characters left characters exceeded