Avoid INSERT in LOOP for INSERTING third party DATABASE using NATIVE SQL COMMANDS

Former Member — Tue, 28 Mar 2017 19:06:34 GMT

Hello Experts,

I am trying to update a database tables in a thirdparty system - with data 
which is extracted from SAP using NATIVE SQL COMMANDS.

LOOP at ITAB into WORK_AREA.
EXEC SQL.
<CODE>
<INSERT>
ENDECEC.
ENDLOOP.

The amount of data i am trying to INSERT is in MILLIONS and INSERT record byrecord is causing performance impacts. Now in order to avoid this is there
any alternate way to avoid INSERTING records between LOOP...ENDLOOP. Like
using a single INSERT statement for updating all records at once?

I came across same question in multiple thread - None of them had a respons
which would answer this? I understood that this can achieved using 
ADBC Framework(ABAP DATABASE CONNECTION), But currently we do not have 
SAP HANA system nor my client was inclined toward that at the moment.

Links which i came across:
https://archive.sap.com/discussions/thread/1833935
https://archive.sap.com/discussions/thread/1286350

CAN THIS BE DONE?

Any suggestion on this would be great. 

Greets,<br>Karthi.

Re: Avoid INSERT in LOOP for INSERTING third party DATABASE using NATIVE SQL COMMANDS

retired_member — Wed, 29 Mar 2017 06:23:05 GMT

Bulk access is available in ADBC since release 7.40, SP02. See example.

Re: Avoid INSERT in LOOP for INSERTING third party DATABASE using NATIVE SQL COMMANDS

matt — Wed, 29 Mar 2017 08:18:10 GMT

" I understood that this can achieved using ADBC Framework(ABAP DATABASE CONNECTION), But currently we do not have SAP HANA system"

ADBC is not a HANA only technology. Use ADBC.

topic Re: Avoid INSERT in LOOP for INSERTING third party DATABASE using NATIVE SQL COMMANDS in Application Development and Automation Discussions

Avoid INSERT in LOOP for INSERTING third party DATABASE using NATIVE SQL COMMANDS

Re: Avoid INSERT in LOOP for INSERTING third party DATABASE using NATIVE SQL COMMANDS

Re: Avoid INSERT in LOOP for INSERTING third party DATABASE using NATIVE SQL COMMANDS