We help IT Professionals succeed at work.

ROLLUP & CUBE SQL

MilburnDrysdale
on
1,938 Views
Last Modified: 2008-02-01
Hello - I stumbled across a reference to the ROLLUP and CUBE function for use in SQL. I applied it to a simple query that I have ("Group by Rollup (abc, xyz)"), but I get the following error;

ROLLUP in *LIBL type *N not found.

Is this a function that's only available on recent releases? I'm not the adminstrator butI think our version is "V5R4" if that makes any sense.

Comment
Watch Question

Commented:
I believe ROLLUP was added in V8

-David251

Author

Commented:
david251 - any way that you know of to add it to an earlier version without a complete update?
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
that's what I was afraid of...thanks for the info!

Commented:

Glad I could help, I guess.
Thanks for the points/grade.
-David251
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.