Re: DRDA Connection Support (was news400 goes negative on IBM?)

On 5/22/05, Jon Paris <Jon.Paris@xxxxxxxxxxxxxx> wrote:
>  >> Or should I install DB/2 for xxx (where xxx is the other platform) to
> get one (tiny) function operational?
> 
> Carel,
> 
> I guess my problem is that I think the issue here is _who_ should be
> supplying the driver/connection/name_of_your_choosing ?
> 
> ODBC and JDBC are standards which most everyone supports.
> 
> DRDA is a database connection standard that IBM and a number of other
> vendors support.  Your iSeries can connect to any DRDA compliant DB.
> 
> Shouldn't we be getting on MS' case for not supporting DRDA?  Just why is it
> the iSeries' fault if MS don't supply a DRDA driver, or if Oracle (who do
> support DRDA) choose to charge for it?  That makes no sense to me.

Is DRDA and open spec in terms of what it takes to connect the as400
to another database?  For example, can MySQL be run in the PASE or a
Linux partition of the as400, then code written to route SQL commands
from an RPG program running on the iSeries to the MySQL database on
that same iSeries?

Using the same method, that is if all the necessary aspects of the IBM
DRDA spec are open and documented, can Windows code be written that
would implement a jury-rigged type interface between the SQL Server
database and a DRDA connection to the iSeries DB2 database?   I assume
that at some level of DRDA an SQL stmt string comes thru that contains
the "select * from table" sql command issued by an RPG program.  A 3rd
party DRDA interface, running on the Windows PC, would process that
SQL "select * from table" stmt by opening a connection to the SQL
Server database, running the sql command, capturing the resulting data
set, then sending that resulting dataset back to the iSeries thru the
DRDA connection, in the open spec and fully documented form expected
by DRDA.

-Steve

> 
> Is it your contention that IBM should write the DRDA drivers and supply them
> FOC for every platform/database combination under the sun?  Doesn't sound
> very realistic to me.
> 
> Jon Paris
> Partner400
> 
> www.Partner400.com
> www.RPGWorld.com
> 
> --
> 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.
> 
>