Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bulk-Insert for native SQL INSERT statement

Hi.

We run into a big performance problem by inserting data sets to an external Oracle data base.

The identified problem is the native SQL insert statement itself.

It seems that there is no chance to execute a Bulkinsert with native SQL.

I tried several ways to develope natvie SQL logic. Including online generated subroutine pools, generated reports, ADBC Classes, inline EXECSQL statements etc. All versions propably working but the performance of insert statement.

We need to export millions of data sets and it is not practicable to execute one insert statement for a single dataset.

Is there any way to boost the performance for inserting data sets?

No Open SQL is possible because the target DB is not the SAP DB (Multidatabase connection).

Thanks in advance

Former Member
Not what you were looking for? View more on this topic or Ask a question