If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

i am trying to do some olap like creating Star schema and doing some data mining based on that .... i hope i am clear now...Its possible using Cube Views. But now cubes views is not possible in db2 9.5( i think i am new to DB2 itself) because i have to install Design Studio which is a part of info web sphere and i am wondering is there any way i can work around!!!

More specifically, see pages 591-596 of the DB2 9.5 for LUW version of this manual, and the examples on pages 605-611.
You can GROUP BY:
- grouping sets
- rollup
- cube
or any combination of these (also combined with single column grouping, or grouping by expression).
Example (from the manual):

Code:

SELECT MONTH(SALES_DATE) AS MONTH,
REGION,
SUM(SALES) AS UNITS_SOLD,
MAX(SALES) AS BEST_SALE,
AVG(SALES) AS AVG_UNITS_SOLD
FROM SALES
GROUP BY CUBE(MONTH(SALES_DATE),REGION)
ORDER BY MONTH, REGION

will return summaries per month, per region, per month/region combination, and a grand total row: