Skip to Content
0
May 21, 2020 at 08:43 AM

Is there a way 'wrap' insert SQL IN SAP Business Connector?

25 Views

Hello.

Currently I have to use RFC FM for update certain amount of data (about 20k row, 15 columns).

I'm using DML Update clause like this :

INSERT tab values (f1, f2, f3, f4, f5); COMMIT;

INSERT tab values (f1', f2', f3', f4', f5'); COMMIT;

But I want to use 'wrapped clause' by resource reason, like this :

INSERT tab values

(f1, f2, f3, f4, f5)

(f1', f2', f3', f4', f5')....

Is there a way to 'wrapping' work in SAP Business Connector in Flow Services? At least other resource-usage-reducing techniques?