Jdbc Reaciver UPDATE_INSERT

[Former Member]

Hey Guys,

Here i am doing an Update_INSERT Senario.

I am following ..Below documnets.

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

Statement

TableName

Action= UPDATE_INSERT

MYTABLE

access

Feild1 is Primarykey

feild2 is Primarykey

feild3

Key

Feild1

Here i should not insert a Doublicate values in ORacle can some one help me here

Thanks for helping me all these days

Regd's

Raj

[Former Member]

My question is not to insert the Duplicate values in

SO in what way do i need to desing a <Key> Structure.

Regd's

Raj

[bhavesh_kantilal]

Raj,

Your query is not very clear. Can you give us examples with some table strcutre.

Also, please closed and update your earlier threads if your problem has been solved.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

MY query is.

In place of action or my constant i am useing <b>update_insert</b>

i am Custom id already exit in oracle table it should not be update.

If the customer id not exist then it need to be insert .

for that what sort of <Key> structure do i need to use.

thanks for helping me

Regd's

Raj

[bhavesh_kantilal]

Raj,

hmm.. now this is tricky.

One option ~~ Select all Customer ID's from your DB table using select, check the list of values with your vallue and only if it is not available then INSERT using the JDBC adapter.

This will need a BPM with a Synchronous Select as well as a Separrate INSERT.

Another optionn~~

Pass the cusomer ID to a Stored Procedure using a JDBC adapter and then the Stored Procedure will decide if it need to update / insert or ignore this customer id.

Option 2 is a better way to do it as it avoid a BPM>

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

Can you please Clearly explain me about store procedure if you have any blogs can you please forward me.. so i can complete the request. i am not going to use BPM. One more thing where should i need to write store procedure.. here.. So do i need to change my Hole stucture now..

Regd's

Raj

[bhavesh_kantilal]

Stored Procedures,

take a look at this blog,

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

<i>So do i need to change my Hole stucture now..</i>

Yes , you will have to. For info on teh strcutre look into the online documentation

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

See the part under STATEMENTNAME5.

[Former Member]

Hi

raj go through this blogs it will give yoou complete idea

/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

regards

kumar

[Former Member]

Hi

Bhavesh

the blog which you have given

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

it will work for IDOC TO JDBC scenario

regards

kumar

[bhavesh_kantilal]

The blog by sriram is meant to be a starting point. You will need to make changes according to your Stroed Procedure and requirements.

Regards,

bhavesh