How do I "link" to other databases using DB2 PL/SQL
I am very new to DB2 and will soon be writing some DB2 PL/SQL.
The purpose of the PL/SQL will be to propagate data from one DB2 database
to many others DB2 databases. In Oracle, you can create a "Link" which allows
you to connect to other databases and perform data manipluation.
Does DB2 have anything like an Oracle "Link"?
Thanks,
Jennifer
# 1 Re: How do I "link" to other databases using DB2 PL/SQL
Hi Jennifer,
There is such a feature. DB2 generally calls it "federated databases", and the
link you end up with is a "nickname". Search DB2's online documentation for
"federated" and "nickname" for instructions.
Also worth considering, DB2 comes with DataPropagator for replicating data. See
the online manual called "replication guide and reference".
--Greg
Jennifer Siegel wrote:
> I am very new to DB2 and will soon be writing some DB2 PL/SQL.
>
> The purpose of the PL/SQL will be to propagate data from one DB2 database
> to many others DB2 databases. In Oracle, you can create a "Link" which allows
> you to connect to other databases and perform data manipluation.
>
> Does DB2 have anything like an Oracle "Link"?
>
> Thanks,
>
> Jennifer
# 2 Re: How do I "link" to other databases using DB2 PL/SQL
Jennifer,
Just so you know, PL/SQL is a Oracle specific stored proc/trigger language.
In DB2, stored procs can be created in C, Java or the SQL procedure language.
And, depending on the platform, I think other languages. Greg and Kevin
would probably know. I've stayed away from them in DB2 as much as possible
(I've only done triggers in DB2) because we are trying to stay database independent.
Mark
MarkN at 2007-11-12 0:00:42 >
