RE: DB2 OLAP functions

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

I was under the impression that OLAP is a chargable feature, not yet part of
DB2/400.  Ah, here it is....

http://www-3.ibm.com/fcgi-bin/common/ssi/ssialias?infotype=an&subtype=ca&app
name=Demonstration&htmlfid=897/ENUS202-310

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Bala, Narsi [mailto:Narsi_Bala@xxxxxxxxxxxxxx]
Sent: Thursday, April 15, 2004 3:20 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: DB2 OLAP functions


Hi,
 
I am trying to use the Rownum() over()  OLAP function but without much
success. My query is 

"select  field1, rownum() over(order by field1)  as rownum from
<library>.<fileName> where field1 like 'A%' and rownum < 10" 

I expect it to fetch me the first 10 records where field1 is like 'A%'
...but i get a SQL0104 Token ( was not valid. Valid tokens: , FROM INTO.
Cause . . . . . :   A syntax error was detected at token (.  Token ( is not
a valid token. 

What am I doing wrong ?

Do i need any special libraries to use these functions ?

Lastly forgive me if this is not the right forum, in which case can anyone
guide me to the right one.

TIA
Narsi






_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.