Skip to Content
avatar image
Former Member

HANA XSJS Bulk Update (PUT operation)

Hi all,

I have a scenario to do Batch operation/ bulk update on my Hana table.

To perform this I suppose to use HANA XSJS.

I have a SAPUI5 screen with 10 text boxes, as soon as user fills the text box and enters the save button, the complete 10 fields should get updated into HANA table via XSJS with serial numbers.

Can you please help me to figure this out.

Regards,

Vicky.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 20, 2015 at 03:59 AM

    Hi,

    You can use odata update() method for the PUT request. Use this link for reference OData Write Support - UI Development Toolkit for HTML5 (SAPUI5) - SAP Library

    Regards,

    ThamizharasaN.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vicky,

      This is absolutely possible. Once the next button is pressed the captured values in the array has to be pushed to table, hence call the procedure.

      Inside the procedure you can have an UPSERT statement which will insert the values into the table.

      Once user enters next 10 values and presses save button, the same procedure can be called which will insert it if its new values or does update if its existing values.

      This way concurrency can be maintained.

      Regards,

      Anil