delete all table entries before updating with JDBC

[Former Member]

I have a scenario. Proxy -> JDBC...

I am doing a full load/update to an oracle database table. Before I update the table with the full update I need to delete all the entries. I would like to send one message through XI, but I need to know if I can send over the first statement in my JDBC to delete all entries in a table, then proceed to update the table again with the next statement.

Any help would be greatly appreciated.

Thanks

Skip Ford

[Former Member · Accepted solution]

There is similar thread talking about same thing, could you reference it:

Liang

[VijayKonam]

You can do a BPM with one Send step for JDBC for clearing the data and then for sending the data..

VJ