Bulk-Insert for native SQL INSERT statement
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