RE: DB2 SQL window functions

["Chris Payne" <CPayne@xxxxxxxxxxxxxxx>]

Here is an article that describes the features that I am trying to use.
I note that they mention only UNIX, windows and OS/2. 

http://www-128.ibm.com/developerworks/db2/library/techarticle/lyle/0110l
yle.html

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Payne
Sent: Monday, February 06, 2006 2:13 PM
To: midrange-l@xxxxxxxxxxxx
Subject: DB2 SQL window functions

I recently purchased the SQL cookbook from oreilly, and one of the
topics is something called "window functions". According to the book
this is one of a whole group of analytical functions that was added in
the SQL - 99 standard. I tried to run the very simple query:

 

SELECT 

SUIT, 

WEIGHT, 

count(*) over() 

FROM 

cpayne.window

 

and got the response:

 

Token ( was not valid. Valid tokens: , FROM INTO.      

 

Does anyone know about these window functions? Have they been
implemented in DB2/400?

___________________________________
Christopher Payne
CPayne@xxxxxxxxxxxxxxx
System Administrator/Programmer

 

The Crown Group
Corporate Offices
2111 Walter Reuther Drive
Warren, MI 48091-6199

 

Phone: (586) 575-9800
Direct: (586) 558-5317
Fax:  (586) 575-9856