× 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.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.