Re: Read a DB file from a 6000

["Patrick Townsend" <patownsend@xxxxxxxxxxxxxx>]

Chris,

As far as I know there is no ODBC client for the AS/400. Many relational
databases support IBM's DRDA interface. Since RS/6000 is an IBM product you
might look in this direction. If DRDA is supported on the RS/6000 it would
not be too hard to map a remote database directory from the AS/400.

We normally take the approach of using a socket client/server on the AS/400
and UNIX (NT, etc.) system. The UNIX application uses the SQL CLI interface
to talk to the relational database. Sockets is supported on all flavors of
UNIX. And SQL CLI is an ANSI standard and is supported by all the major
relational databases. The performance on this approach tends to be good,
too.

Patrick
---
IBM AS/400 communications, FTP automation, and eCommerce
software and consulting services.

http://www.patownsend.com

----- Original Message -----
From: Quazy <quazy@SoftHome.net>
To: <midrange-l@midrange.com>
Sent: Monday, October 16, 2000 11:29 AM
Subject: Read a DB file from a 6000


> I need to read a oracle data base file on a RS/6000 from my AS/400.   Is
> there a way to do a ODBC connection from the as/400?   or is there another
> way to do this.  I don't want to ftp the file to the as/400 because I
don't
> know how often it will get changed.   The file will get read quite
> frequently, so I need pretty good performance.  It will have the
> possibility to be read up to 80,000 times in one day.
>
> Any suggestions would be greatly appreciated.
>
>
> Chris
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---