Proxy to JDBC Update

[vijay_kumar133]

Hi Friends,

I have a issue in proxy to JDBC update. there are onley 4 fileds to be inserted into table..

And before inserting the fileds into table i need to check whether the fields are there or not if not insert if they are then update,, i need to check all the four fields. for this..

Any way to solve this kind of issue..

Regards

Vijay

[Former Member]

But what is the need of it?

In both cases you have to perform some action on database.

1. If records are there then Update

2.If records are not present then Insert.

So if even you check the records prior to sending it to database....you have to do the same(Inster or Update) and UPDATE_INSERT is possible with JDBC rec. adapter.

Then why you need to check it? Is there any business logic behind it? Or you it was jut for practive purpose?

Thanks

Farooq

[vijay_kumar133]

Hi

The business logic..

I am updating the fileds on change data by using AEDTM as logic.. but some time bdcs are running and updating all the records so i am getting duplicate records from the table. so i need to do the same when records are there update them if not insert.. can we use both at a time by using insert and update..

Regards

Viajy

[prateek]

Perform JDBC lookup as I said. If the value does not exist, insert the data, otherwise u may raise an alert and stop the processing.

Regards,

Prateek

[prateek]

Use JDBC lookup before inserting the data.

Regards,

Prateek