RE: Need way to retrieve data from an external database

You could use JDBC to get the information. I would probably write a
sockets program for both sides, or use MQ Series. 

> -------- Original Message --------
> Subject: Need way to retrieve data from an external database
> From: "Cambra, Charlene" <Charlene.Cambra@xxxxxxxxx>
> Date: Fri, March 18, 2005 3:38 pm
> To: <midrange-l@xxxxxxxxxxxx>
> 
> 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.