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

Question

Is something like this possible in SQL/DB2?

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

I always 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

I do that all the time on our DB2...are PROD and TEST your library names? Have you tried it with / instead of . between the names? — Leslie, Oct 12 '10 at 17:48
I am not allowed to change any settings on the database. It runs on AIX. The main problem is, that the Prod and the Test databases are on different servers. — Stefan, Oct 13 '10 at 13:56

score 0 · Answer 1 · edited May 23 '17 at 12:08

0

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

edited May 23 '17 at 12:08

Community

answered Oct 12 '10 at 12:47

Preet Sangha

It's possible to create the synonym, but ater that I get the same Error message. – Stefan Oct 12 '10 at 12:55

1 Answers1