RE: Need way to retrieve data from an external database

["Kurt Goolsbee" <kurt.goolsbee@xxxxxxxxxxxxx>]

There are many ways to architect a solution.  A type 4 JDBC driver would
allow you to connect directly from a Java program on the iSeries to the
remote database.  You could also write a java program that runs off the
iSeries that the Java Toolbox to broker requests to the database via *DTAQ
objects.  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
michael@xxxxxxxxxxxxxxxxxx
Sent: Friday, March 18, 2005 2:58 PM
To: Midrange Systems Technical Discussion
Subject: 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.

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