我可以连接来自 2 个不同 DB2 数据库的数据吗?(如 SQL Server 链接数据库) [英] Can I join data from 2 different DB2 databases? (Like SQL Server linked databases)

问题描述

我正在增强现有的 java 应用程序.在 2 个不同的 DB2 数据库中有数据.该应用程序已经从 2 个不同的数据库中获取数据，但它总是先从一个数据库中查找，然后再从另一个数据库中查找.有没有办法使用一个 SQL SELECT 连接来自 2 个不同 DB2 数据库的数据?

I'm enhancing an existing java application. There is data in 2 different DB2 databases. The app already gets data from 2 different databases, but it always does a lookup from one and then the other. Is there a way to join data from 2 different DB2 databases using one SQL SELECT?

这是我尝试过的:

CREATE ALIAS remote_orders FOR remote_db.schema.orders;

select *
from myid.remote_orders a
inner join local_schema.parts b on (a.key = b.key)
with ur FETCH FIRST 200 ROWS ONLY

我收到此错误:

STATEMENT REFERENCE TO REMOTE OBJECT IS INVALID. SQLCODE=-512, SQLSTATE=56023, DRIVER=4.14.113

我可以用临时表做点什么吗?我可以毫无错误地运行此选择，但它对我没有帮助......(还)

Can I do something with a temp table? I can run this select with no errors, but it does not help me... (yet)

select *
from myid.remote_orders
with ur FETCH FIRST 200 ROWS ONLY

DB2 临时表可能会有所帮助.我能够创建一个.现在我需要(上床睡觉)并尝试选择它，然后加入.

A DB2 Temp Table might help. I was able to create one. Now I need to (go to bed) and try selecting into it and THEN doing my join.

推荐答案

使用完全限定名..

类似:

select *
from DB1.myid.remote_orders a
inner join DB2.local_schema.parts b on (a.key = b.key)
with ur FETCH FIRST 200 ROWS ONLY

这篇关于我可以连接来自 2 个不同 DB2 数据库的数据吗?(如 SQL Server 链接数据库)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！