on 11-30-2010 12:58 PM
Hello Gurus,
I have a requirement in the project. When I do message mapping, I need to delete all the entries in the target table and then insert the new rows. From searching the old posts, I know it is possible without BPM. Can anyone please help me out? I really appreciated it.
Regards,
Bai
Hi,
in msg mapping, in target JDBC structure have 2 table nodes......in first have action as DELETE and table as TABLE_NAME without any field conditions......in second have action as INSERT and table as TABLE_NAME and fields in access node......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your replies. It worked fine. However there is another outstanding issue. WHen I send 2250 records in 1000 package size, there will be only 250 entries inserted in the JDBC table. That is because 2250 records have been splited up to three messages (1000/1000/250). Each message carries a DELETE action. If I send one message with 2250 records, there is no problems. Any idea how to resolve it? I tried to find a simple solution to resolve it. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bai,
Check the below links:
http://help.sap.com/saphelp_nwpi711/helpdata/en/43/9519abb1146353e10000000a11466f/frameset.htm
Defining a DELETE Statement
http://help.sap.com/saphelp_nwpi711/helpdata/en/44/7b6e85fde93673e10000000a114a6b/content.htm
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.