Re: external database connectivity

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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