Re: SQL Rollup Feature

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

-----Original Message-----
From: MCPARTLAND, Stan <stanley.mcpartland@bently.com>
To: 'MIDRANGE-L@midrange.com' <MIDRANGE-L@midrange.com>
Date: Wednesday, July 19, 2000 11:23 AM
Subject: RE: SQL Rollup Feature


>I don't know if rollup and cube are "standard" SQL, but assume so since
they
>are supported by Oracle, MS, and other IBM databases.  I checked the
>documentation for DB2 NT ver 6 and it supports rollup and cube.  I don't
>remember when version 6 came out, but version 7 has been out for a month or
>two.  Maybe DB2/400 will catch up when V5 comes out.


Actually, my order of 7 is delayed. Just like the #@*! T20 notebooks they
are pushing and saying you can order, they just can't deliver.

And I doubt that V5 will have caught up...  the LOB support was in DB2/2
Version 2 in 1995 and the 400 was supposed to have it in V4R2, then R3, then
R4.  Cube and Rollup by version 5? HA! Don't hold your breath.

But gee, let's see, we have PASE, so if you order the AIX version of DB2 UDB
V6 or V7 and install it on the 400....   <vbg>

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

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---