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

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Ron Adams
>
> 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?

You are forcing the query to the CQE instead of the SQE.  For example, if
dopordm0 is a DDS logical, it won't work.  Check this:

http://archive.midrange.com/midrange-l/200705/msg00764.html

Joe