Re: SQL data access

Thanks for the prompting, Nathan!! ;-)

As far as I know there is no way to use F-specs for non-iSeries data - unless 
you were to use a SPECIAL type, maybe, and those have some strong limitations.

Shannon mentioned the use of Java - that'd work. IBM has the WebSphere 
Information Integrator (or some such name). It is software that has an iSeries 
piece and a PC piece - it lets you use embedded SQL to talk to other database 
engines from RPG - the PC app fills in as a DB2 database and communication uses 
DRDA.

<blatant vendor response>
And we have a similar solution called RPG2SQL Integrator that operates in much 
the same way, except we use function (ILE procedure) calls. This is very 
similar to using SQL CLI (Call-Level Interface). Here's the commercial - give 
me or us a call at 888.RJS.SOFT if you want to take a look at it. It also has 
strong Excel features that use Windows OLE automation instead of SQL.
</blatant vendor response>

There is a good interesting article by Kent Milligan of IBM - search google on 
the words heterogeneous and "data access" maybe. Of course, it is slanted 
toward the very costly IBM solution.

If you were trying to talk to Oracle, they have a provider that runs on the 
iSeries and gives you DRDA (embedded SQL) functionality. Pricy, of course.

HTH
Vern


-------------- Original message -------------- 
From: Nathan Andelin <nandelin@xxxxxxxxx> 

The folks at: 

http://www.rjssoftware.com/ 

sometimes respond to questions like this. 



----- Original Message ---- 
From: Mike Skvarenina 
To: MIDRANGE-L@xxxxxxxxxxxx 
Sent: Thursday, October 19, 2006 12:06:35 PM 
Subject: SQL data access 




Is there a tool that could emulate an AS/400 database file but really points 
to a table on a Windows server living in a SQL database so an RPG program 
could simply declare a file from a F spec? 

I know the alternative is to invest in a product like DataMirror or Mimix to 
create a duplicate copy of the data on my AS/400 but I'd like to eliminate 
the mirrored copy if possible. 



-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l. 







-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options, 
visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
or email: MIDRANGE-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/midrange-l.