External DB2 Database link/trigger

810 pts.
Tags:
AS/400 database
DB2/400
i5/OS
IBM DB2
iseries 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Teandy
    For some reason the links did not come through. Here they are again: Try this article here: http://systeminetwork.com/article/open-door-non-iseries-data Also, this thread here may be of some help. http://archive.midrange.com/rpg400-l/200210/msg00501.html
    5,860 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following