Receiver JDBC

[Former Member]

Dear All,

I am working on a File-XI-JDBC scenario. My requirement is that before inserting the records in the database it should first check what all entries are already existing in the database wrt a particular column value. If an entry is found in the database then that entry should not be inserted rest all data should be inserted.

I have tried with UPDATE & INSERT command at receiver end but it is not checking for the existing records.

Kindly guide me on this.

Regards,

N.Jain

[former_member183906 · Accepted solution]

Hii

have a look at this page:

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

you can us action - UPDATE_INSERT

if you want to do update or insert (in case update is not possible)

http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/frameset.htm

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

http://help.sap.com/saphelp_nw04/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

Check this JDBC Adapter Configuration Guide:

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

[Former Member]

there is no need to check existing record if you maintain the Primary keys well at both side , if any change is record is there it will update ,

if you still want to check JDBC Lookup is the best option ,which you can perform by UDF/mapping very easily.

regards,

[dharamveer_gaur2]

use Redo

However, if the error occurs because the message was saved in the database when it was first processed and it is still located there, processing can be completed for the sender system using the value Repeat (note that the database interface normally triggers the error duplicate insert if at least one of the table fields was defined as a primary key). Otherwise the sender system will continue to send the message and the error will continue to occur.

see link:http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

[Former Member]

hi

use the look ups in mapping and then insert

check this blog

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

regards

kummari