on 09-20-2006 2:39 PM
Hi Guys,
I am new to XI, I have a query.
I have a interface which inserts data in SQL server. I am entering data in 3 different tables at a time.
When any error occurs insert in all 3 tables is rolled back. I want to avoid this, I would like to continue inserting data in one of the 3 tables even if error occured in either of the 2.
Is this possible??
Thanks in advance...
Hi Anand,
in the communication channel it is not possible.
The workaround is to call the adapter n-times; for each table separate.
Regards Mario
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
You can do this by calling stored procedure in your JDBC adapter.
We can use stored procedure to insert the data into two tables.
http://help.sap.com/saphelp_nw04/helpdata/en/e2/cb610b230c9c4cb4b800989196b63a/frameset.htm
Please use this structure while calling Store procedure from communication channel.
Nanda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.