SQLCode -512

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Sarge - 29 Dec 2004 21:49 GMT

I attempt the following:

select * from my.table1
union
select * from remote.my.table1

and I get sqlcode -512: The query reference to a remote object is invalid.

This is on DB2 for z/OS v 7.1.2, DBPROTOCOL(DRDA). Have tried it with
spufi, QMF, QMF for Windows, all return the same result. The remote
database can be DB2 for zOS or DB2/UDB on Windows, and it does not matter, I
still get the -512. I can no find no reference in the documentation stating
I cannot join or union to a table in a remote database using protocol DRDA.

Any suggestions?

Thanks in Advance.

Signature

David Sarge
State of Georgia, Department of Revenue
DB2 Certified DBA
Oracle Certified DBA

--
David Sarge
State of Georgia, Department of Revenue
DB2 Certified DBA
Oracle Certified DBA

Reply to this Message

Walter Schneider - 30 Dec 2004 15:55 GMT

Hello,

DB2 for z/OS currently does not support referencing local and remote tables
or remote tables from different locations within a single SQL-Statement!
Only way to accomplish this under z/OS is to establish a federated database
on DB2 for Unix/Windows/Linux. Within this db, you can define references to
any other database of the DB2 family and define views that join this remote
tables together. It's a little weird since then you access the local tables
also as remote ones, but it works!

Cheers - Walter.

> I attempt the following:
>
[quoted text clipped - 13 lines]
>
> Thanks in Advance.

Reply to this Message

David Sarge - 30 Dec 2004 17:33 GMT

Walter,

I am aware of that option. The strange thing is that I do not find
anything in the DB2 zOS 7.1 docs that says I can't do this w/DRDA protocol.

Thanks for the response.

David Sarge

> Hello,
>
[quoted text clipped - 35 lines]
>>
>> Thanks in Advance.

Reply to this Message