Solved

ROLLUP & CUBE SQL

Posted on 2006-06-14
5
1,907 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.

0
Comment
Question by:MilburnDrysdale
  • 3
  • 2
5 Comments
 
LVL 19

Expert Comment

by:david251
ID: 16902364
I believe ROLLUP was added in V8

-David251
0
 

Author Comment

by:MilburnDrysdale
ID: 16902393
david251 - any way that you know of to add it to an earlier version without a complete update?
0
 
LVL 19

Accepted Solution

by:
david251 earned 500 total points
ID: 16902470
sorry, I don't think there is a way.  BTW, I am stuck in the same position as you are.  My company is also on a previous version.

-David251
0
 

Author Comment

by:MilburnDrysdale
ID: 16902527
that's what I was afraid of...thanks for the info!
0
 
LVL 19

Expert Comment

by:david251
ID: 16902750

Glad I could help, I guess.
Thanks for the points/grade.
-David251
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question