Re: Need way to retrieve data from an external database

[pnelson@xxxxxxxxxx]

RPG2SQL from RJS Software (www.rjssoftware.com) can help you here.

Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx





"Cambra, Charlene" <Charlene.Cambra@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/18/2005 02:38 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     <midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Need way to retrieve data from an external 
database


Hello,
We are currently involved in a project that requires the iSeries to
retrieve data from a table existing on another server (not an iseries).
I tried to set up a relational database entry and use SQL connect but
the other system doesn't have the DRDA standard.  I'm really not sure
how to go about getting the data.  We need to access this real time,
from an interactive order entry screen on the iseries.  The external
database will be  used to hold customer information and if the customer
is placed in a "hold" status in our ERP system which resides on the
iseries.
Thank you!
Charlene
 
-- 
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.