RE: news400 goes negative on IBM?/RE: DRDA Connection Support

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

comments in-line

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Hatzenbeler, Tim
> Sent: Monday, May 23, 2005 6:09 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: news400 goes negative on IBM?/RE: DRDA Connection Support
> 
> 
> So that brings up the question, is there a DRDA/rdbms <-> 
> ODBC Bridge ...
> Type of application that runs on a pc...

IBM's DB2 Information Integrator (formerly know as DataJoiner) is a DRDA-->ODBC bridge like you describe.

IBM's product is the only DRDA-->ODBC bridge I know of.  Oracle's Access Manager product is a DRDA-->Oracle bridge and products such as RPG2SQL are a proprietary-->ODBC bridge.


> 
> We setup drda on our end (iseries), and it picks up the 
> (drda/odbc bridge)
> client on the pc, it translates the calls to odbc, (hits the 
> database) ...
> Gets a result, and then passes it back, in a drda format..

Yep.  But it cost something like $25,000.

> 
> 
> As for using rpg/java to connect to a remote database via a 
> jdbc call, can
> that actually be done?  I have seen some 'java methods' used 
> from inside
> rpg, but I have not seen a full blown sql select, process the 
> result set,
> type of program... Is that even possible?
> 

Actually, the best way I've seen it done is have a Java daemon waiting on SQL requests to be placed into a data queue.  Your RPG program adds a request to a data queue and waits for the Java daemon to place the results into another queue.

There was an article that used this technique in iSeries Network.  It was pretty basic, always sent the SQL to a particular SQL server.  But it wasn't hard to expand upon the original idea with multiple SQL and/or Oracle servers.


HTH,
Charles