RE: SQL Rollup Feature

["MCPARTLAND, Stan" <stanley.mcpartland@xxxxxxxxxx>]

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.

Regards,
Stan

-----Original Message-----
From: Richard Jackson [mailto:richardjackson@richardjackson.net]
Sent: Tuesday, July 18, 2000 6:35 PM
To: MIDRANGE-L@midrange.com
Subject: RE: SQL Rollup Feature

<snip>

IBM prides itself on confirming to standards.  Is the rollup keyword in some
standard or is it an Oracle extension?  For what it's worth, I think that it
is kind of cool.

LATER: I just did a quick search on the IBM AS/400 web site and "rollup" or
"roll up" as SQL keywords aren't there.

Richard Jackson
mailto:richardjackson@richardjackson.net
www.richardjacksonltd.com
Voice: 1 (303) 808-8058
Fax:   1 (303) 663-4325

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