Re: INSERT, UPDATE, or DELETE based on a JOIN
I assume the IBM machine is not running MySQL?
There is no way to JOIN between two machines running two different database engines.
I would get both sets of data on the same machine in the same engine. Then do JOINs to list the ids to delete, the ids+values to change, and the ids+values to change. I would do this in some programming language so I could output 3 SQL statements (or sets of statements) that would do INSERT, DELETE, UPDATE. Then I would execute them (remotely, if necessary) to do the task.
Lookup the INSERT and UPDATE syntax for "multi-table" operations. There are probably similar syntaxes for the IBM box.
Subject
Written By
Posted
Re: INSERT, UPDATE, or DELETE based on a JOIN
May 15, 2013 08:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.