External DB2 Database link/trigger
Home > IT Answers > AS/400 > External DB2 Database link/trigger
R.otto
435 pts.
0
Q:
External DB2 Database link/trigger
AS/400 database, DB2/400, i5/OS, DB2, V5R4
In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.
Software/Hardware used:
i5 i5/os v5m4
ASKED: Oct 26 2009  10:42 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
TomLiotta
7730 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Are you asking how to do this on the i5 or is there some other question i'm not seeing?

-----

Appearantly part of my question disappeared somehow.

I wanted to know if it is possible to connect from the i5 to an Oracle database and whether it is possible to have triggers on that external DB so if anything changes some action can be triggered.
And, if this is possible, how to do it.

TIA
Rudolf

========================================================

As with all databases, it is the vendor's responsibility to create drivers, to adhere to standards and/or to document database connection protocols. You can purchase connectivity from Oracle or use their JDBC Thin driver, a Type 4 driver which means it's supposed to be pure java making it platform-independent.

If the Oracle system has full DRDA support installed, you should be able to get decent access the same as you might with other DB2 products. An entry in the remote database directory would be a first step.

Tom
Last Answered: Oct 29 2009  5:27 AM GMT by TomLiotta   7730 pts.
Latest Contributors: R.otto   435 pts., Teandy   3250 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Teandy   3250 pts.  |   Oct 27 2009  6:22PM GMT

Try this article here:

Also, this thread here may be of some help.

 

Teandy   3250 pts.  |   Oct 27 2009  6:23PM GMT

For some reason the links did not come through.

Here they are again:

Try this article here:
 <a href="http://systeminetwork.com/article/open-door-non-iseries-data" title="http://systeminetwork.com/article/open-door-non-iseries-data" target="_blank">http://systeminetwork.com/article/open-d…</a>

Also, this thread here may be of some help.

 <a href="http://archive.midrange.com/rpg400-l/200210/msg00501.html" title="http://archive.midrange.com/rpg400-l/200210/msg00501.html" target="_blank">http://archive.midrange.com/rpg400-l/200…</a>

 
0