JDBC requirement

[Former Member]

Hi

My scenario is file - xi- jdbc. Here I want to delete the entire records in the database and insert the new one. Normally update command is used to delete the records which matches and to create the new if it won't exist. But in this case how will we do that ??

thanks

kumar

[Former Member · Accepted solution]

Kumar,

Why do you want to delete the record and insert the new one once again?

Else write a stored procedure and execute it from XI.

---Satish

[Former Member · Accepted solution]

Hi Satish,

Could you please tell me what do you mean by stored procedure ??

thanks

kumar

[Former Member · Accepted solution]

Kumar,

If you have any database guys with you kindly please check with them about this?

or Do a google search on Stored procedure. You will have enough information.

---Satish

[Former Member]

Hi Palnati,

For this you will have to use synchronous select in JDBC adapter.

Just go through this blog

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

This is surely going to help you.

Thanks

Amitanshu

Reward Points If useful