Hi,
I'm getting acquainted with Federated data. In this context I've a
question. On LUW I can create nicknames for tables on DB2 for zOS .
What is the equivalent action on DB2 for zOS? How do I refer to a
table on an LUW DB2 instance? Do I use alias? If so how do I create
this? I don't want to explicitly connect from my application (Cobol)
if I don't have to.
Thanks!

On May 5, 3:47*pm, chuck <charles.levi... (AT) gmail (DOT) com> wrote:
Not sure how zOS support Federation, but you can connect to UDB
directly from Cobol.

On May 6, 12:27*pm, Anwei Shen <shenan... (AT) gmail (DOT) com> wrote:
Yes that's true by making the requisite entries in the CDB
(SYSIBM.IPNAMES and SYSIBM.LOCATIONS etc) I can connect to LUW. But
how can I join a zOS table with an LUW table from a Cobol program on
the mainframe (I could define nicknames for the zOS Db2 tables on LUW
and accomplish but that seems roundabout!)

chuck wrote:
is to set up a Federation Server on LUW with a Federated database
defined "in front of" two DB2 for LUW databases. Then, you can set up
that Federated database as a DRDA-AS to be served by the DB2 on z/OS as
a DRDA-AR. I know that I've seen this kind of environment set up when a
mainframe DB2 app requires access to a non DB2 LUW db (e.g. Oracle) via
Infosphere Federation Server.

Larry Edelstein

--- news://freenews.netfront.net/ - complaints: news (AT) netfront (DOT) net ---