DB2 - SQL Querie Insert Rows from one DatabaseA.Table to DatabaseB.Table

Question

Hi,

is something like this possible in SQL/DB2?

INSERT INTO Prod.CD_Final (ID) VALUES (SELECT ID FROM Test.CD_Final);

I alway get the error message: "Prod.CD_Final" is an undefined name. SQL Code: -204, SQL State: 42704 "Test.CD_Final" is an undefined name. SQL Code: -204, SQL State: 42704

Thanks, Stefan

Answer 1

I think the two dbs need to be Federated I think. See here

• also see here : http://stackoverflow.com/questions/314684/cross-database-queries-with-different-db-names-in-different-environments