on 08-08-2007 11:16 AM
hi
i hav a scenario in which i need to update customer details in two tables using JDBC adapter without using BPM...
do i need to take care about target sturcture..in this case..
pls give me answers ASAP
thnks
satya
Hi Sathya,
I hope you can do this with Procedures. So procedures can have multiple statements and by this way you can update how many tables you want to update you can do.
Warm Regards,
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please use stored proceedure to create an SQL update statement for two tables. Give the necessary arguments you need to give in the stored proceedure.
From <a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter</a>
Choose the one for Stored proceedures i.e EXECUTE and map your XI Payload to the arguments as required..
It should do the job
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ref:
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
you need to have multiple ACCESS level tags in the output one for each Record. This will Update multiple records in the Database.
The ACCESS tag occurence should be 0 to unbounded and each record in the source should create a ACCESS level tag with the corresponding lower level tags.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satya,
the best practice is to use stored procedure in jdbc sceanrio as you can implement complex logics in stored procedue.. you can extend procedure as you want without disturbing XI code... so use stored procedure to insert data into two tables..
Ranjeet.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satya,
This link would help you
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.