Skip to Content
0
Former Member
Feb 27, 2009 at 06:56 PM

delete all table entries before updating with JDBC

28 Views

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