Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
How to migrate a subset of data from one table to anotherer
설명
Need to migrate a small number of rows based on a SELECT query (SELECT from table x WHERE id = 111) from a table in one subsystem to the same-named table in another subsystem, not the entire table. Is there a way to do that in Toad for DB2?
해결 방안
1) In Toad, connect to both subsystems. 2) Make the active connection the connection you want to Import to. 3) Tools | Import | Import Wizard. 4) Click the Add Query button, in the Import Wizard. 5) Select the connection, from the dropdown field in the Import Wizard, which you want to import the data from. 6) Enter the query in the space provided that will get you the data you want to import. 7) In the next window, select the table you want to import to. 8) Continue through the rest of the import wizard.
