I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries.
The access to the external database should:
1. Not employ another server. The complete solution must reside in the iSeries.
2. Be coded in RPG(LE) - not in C++ or Java. C++ or Java routines or classes can be called from RPG(LE).
3. Access to the external database must be realtime. The data must NOT periodically be copied onto the iSeries through FTP or something similar.
4. The solution should, if possible, not implement DRDA.
I found 'Information Integrator' on the IBM web site but don't yet know if this will do the job. It is however hellish expensive.
Does anyone know if:
1. This is possible
2. How it can be done
Any help will be appreciated.
August 15, 2006 8:29 AM
November 28, 2011 9:15 AM