Re: DB2 compatibility?

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----Original Message-----
From: David Gibbs <dgibbs@verticalsky.com>
To: 'JAVA400 Mailing List' <JAVA400-L@midrange.com>
Date: Monday, April 23, 2001 11:02 AM
Subject: DB2 compatibility?


>Folks:
>
>Does anyone know if DB2 on the PC (or unix) and 400 have ever been compared
>feature for feature?
>
>I'm trying to determine if the 400 DB2 lacks any features that the PC
>version has ... especially where it relates to JDBC.
>


JDBC support is there and comparable, but the SQL functions are not the
same. The version you call PC or UNIX is actually UDB, preferably V7.1. The
400 version is UDB wannabe. The three flavors are 400, 390 and UDB. UDB runs
on everything  but the 400 and the 390 and comes from Toronto. The 400 comes
from Rochester and the 390 (I think) still comes from Santa Theresa.

The primary difference (at least as of V4R5) is that the UDB version
supports grouping sets, cube and rollup functions, while the 400 does not.
The LOB support is more robust and functional (at least IMO) than the 400.

As for performance, I have not tracked the changes for JDBC, but in the
beginning they all went through ODBC to get there. (Read that CLI.) I seem
to recall hearing that the current UDB driver for JDBC no longer goes
through ODBC. I have not followed the JDBC driver for the 400, but I would
assume that it still goes through ODBC.

I (as JT might point out) could be wrong.

I can't currently speak about the 390 functions, but that may change soon...

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---