Re: Interfacing with non-AS400 systems

I would assume the first question is what type of database is on the RS6000?
There may very well be standard tools to access the database remotely.
Basically you would build a conenction, run the appropriate SQL query, get
the data you need, kill connection.

----- Original Message ----- 
From: "Roy Luce" <lwl@xxxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Tuesday, November 11, 2003 4:04 PM
Subject: Interfacing with non-AS400 systems


> I have an AS400 based application which needs data residing on a RS6000 in
> another city.
>
> The data we need is resident in several tables and what we need is data
> dependent.  For example, if the data in one RS6000 file/table contains a
> given value in a specific field then we need data from several records in
2
> other files/tables.  This is but one of many examples of the data
dependent
> of the extraction logic required in the process.
>
> In the way of background, we have an AS400 process in place today that
> extracts data from existing AS400 tables using the required logic.  What
we
> want to do is extend this AS400-based process to extract data from the
> RS6000's files.  What we do not want to do is send the RS6000 data to the
> AS400 in the form of flat files; the data is too extensive (couple of
> million records every day) and the need for access keys to effectively
> access the data based on relationships says we'd have to build a
supporting
> set of tables.  Since the RS6000's data resides in a relational database
we'
> d prefer to access the data via that database.
>
> I'm looking for advice on how to accomplish our objective and would
welcome
> off line "discussions".  Anyone with experience in this area?
>
> Roy Luce
>
> Main:    847-540-9635
> Cell:      847-910-0884
> Fax:      208-330-9032
> Email:   lwl@xxxxxxxxxxxxx
>
> _______________________________________________
> 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.