RE: ODBC FROM iSeries - huh?

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

I think everything is already on the 400, except the driver for specific
databases. SQL will talk to any DRDA-enabled database. This is,
essentially, the way remote SQL-CLI is implemented. As I've mentioned, it
already works to other 400s and, I believe, any DB2 system (AIX, Windows,
390, Linux, etc.)

The analogue to an ODBC driver is the ARD (I think it's called). This is
named when you ADDRDBDIRE. To me, this is similar to the ODBC setup in
Windows of a data source.

Key is having knowledge of what is the server component (analogous to the
database host server on iSeries) in another DBMS. And how to call its
functions with sockets. The ARD on the 400 just has to translate you SQL
statement to native for the remote database, just as ODBC drivers in
Windows do now.

I think there is documentation for ARDs in the Distributed Database manual.
And the API reference has it under File APIs as "SQL Client Integration
Exit Program"

At 10:59 AM 4/9/02 -0500, you wrote:
>At 04:49 PM 4/9/02 +0100, you wrote:
>>On Tue, 2002-04-09 at 16:36, Vernon Hamberg wrote:
>> > does not look like something that can be put on a 400, to get data
>> > from, say, Oracle or SQL Server. I.e., where the 400 is a client. Their
>> > client list includes OS/390 when you hav its Unix System Services, if I am
>> > reading it rightly. No 400. May be in PASE?
>
>-snip-
>
>>Easysoft are based less than a mile from where I work, so maybe I should
>>ask them about progress on it ;-)
>
>Yes, please!!!
>
>
>>Regards, Martin
>>--
>>martin@dbg400.net  jamaro@firstlinux.net  http://www.dbg400.net
>>/"\
>>DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open        \
>>/
>>Source free test environment tools and others (file/spool/misc)
>>X
>>[this space for hire]  ASCII Ribbon Campaign against HTML mail & news  /
>>\
>>
>>_______________________________________________
>>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>>To post a message email: MIDRANGE-L@midrange.com
>>To subscribe, unsubscribe, or change list options,
>>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>>or email: MIDRANGE-L-request@midrange.com
>>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@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.