[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

ROLLUP & CUBE SQL

Posted on 2006-06-14
5
Medium Priority
?
1,917 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

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…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

650 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