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.
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.