Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 20, 2017 at 10:33 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded