Re: RANK/ROWNUMBER - Function not supported for query?

Message id?


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Ron Adams" <rondadams@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/13/2007 10:24 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RANK/ROWNUMBER - Function not supported for query?







I'm playing around with using RANK and/or ROWNUMBER functions in a
query, but I keep getting the error message "Function not supported
for query"
If I click help on the err msg, it reveals reason code 6 - An OLAP
function is not supported for this query, Recovery - If code 6,
remove the OLAP function from the query

Here's the SQL

select
RANK() OVER (ORDER BY ORDAMT) as NRANK,
ORDNO, CSTNO, ORDAMT
FROM ccsdtatest.dopordm0
where ORDNO like 'CU%'


What am I doing wrong?



--
Ron Adams
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.