Single call Stored Procedure from XI for all rows of data

[Former Member]

Hi Friends,

I am using the stored procedure in target side, XI call the stored procedure for each row to insert the record, Once successfully inserted log table is created,

so that thing i am using the stored procedure here.

We have lot of rows (that means lot of records)for ex 50000 records,presently in my scneario XI call the stored procedure for 50000 times to execute it.

So now i don't want like that, XI insert 50000 rows with in single call Stored Procedure is possible? can you please provide me your valubles?

Thank you very much.

Sateesh

[former_member182004 · Accepted solution]

Hi Sateesh,

I guess that isn't possible, in your target structure (0..N) the JDBC connector makes one call for every message that you've generated. I don't know if there is any walkaraound, you can check this doc from SAP that explains the available formats:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Juan.

[Former Member]

Hi All,

Can you please provide me your valubles points about my question

Thank you

sateesh