Inserting Multiple Rows of Data With One Insert

[#1]

In MySQL, I can insert multiple rows of data with one insert statement by simply comma separating the VALUES part of the statement. How can I batch/bulk/multiple row insert into HANA with one INSERT statement?

[lbreddemann]

Hi Kevin,

nope - HANA does not support INSERT/UPDATE batching via a single SQL command.

However, you can create command batches via JDBC (and I assume also ODBC, but haven't tested that).

- Lars

[rama_shankar3]

Lars,

With JDBC, can we do full roll-back? For example, we have 3 update statements and I want to rollback 1st two updates based on a condition if 3rd update fails?

Please let me know.

thanks,

Ram

a

[lbreddemann]

Hi Rama,

of course, regardless of using JDBC or any other client, HANA's transaction support will always roll back the whole transaction.

- Lars

[Former Member]

This Jun 21, 2019 at 08:21 AM comment indicates that this sort of insert/update batching is now supported. If it is now supported, when did that change?

I'm using JDBC and would prefer to use prepared statements for these inserts. Unfortunately that is not an option due to performance problems.