×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Mahesh
Working with data on non-iSeries machines has long been a challenge.
The preferred way is to use embedded SQL, but that is not possible
for most database systems, because the vendors have not given us the
DRDA "provider" to make this possible. The only vendor who has that I
know of is Oracle. Maybe IBM will do that or has done that with
Informix, since IBM now owns it - but that is a guess - I do not KNOW
that. I just googled for infomix and drda and iseries - apparently
John Brandt on the MIDRANGE-L list in November 2004 said that
Informix IS DRDA compliant.
http://archive.midrange.com/midrange-l/200411/msg00390.html
But I can't find that there is something for the iSeries - Informix
can be a CLIENT to DRDA databases like that on iSeries or DB2 - not
sure that it can be a server for DRDA.
Another option is to use JDBC on the iSeries to work with remote data
- of course, this requires Java expertise.
IBM does have a product called Information Integrator or Data
Integrator, that runs on a Windows box and acts like a DRDA target
system - embedded SQL can talk to it. But it is very expensive - in
the US, typically 30,000 dollars for the product and one database
option, I believe.
<vendor response>
We are a vendor, and we have a product called RPG2SQL Integrator that
consists of a service program and a Windows middleware app. It is not
embedded SQL, rather a set of functions you call to connect to the
database and make SQL requests to it. You have to have an ODBC driver
or OLE/DB provider on the machine where our middleware app is
running. Easy to use, much less expensive than IBM's solution.
You can get more information by emailing sales@xxxxxxxxxxxxxxx or
looking at www.rjssoftware.com.
</vendor response>
There is a paper from IBM by Kent Milligan that is an excellent
presentation of the issues. Go to Google and search for
"heterogeneous milligan" and you will get to a page that will lead
you to this PDF - I forget the link right now. He mentions our
product, along with 2 or 3 other 3rd party solutions. Of course, he
is with IBM and focuses on their solution, which is a good one.
At 06:29 AM 10/31/2007, you wrote:
Hello All,
I have application running on AS/400 and I ha ve another
application which is running on separate server using informix database.
I want my AS/400 application must receive data from informix server online.
So please give me detail solution to receive data from other
server to AS/400 application.
Thanks in advance
Thanks & Regards
Mahesh
midrange.com
