пишу:
select
kecdpr,
keobv1,
keccom ,
kefaci,
(max(kecdpr) over (partition by kefaci,keccom,keobv1 order by kergdt desc)) as ff
from mvxjdta.MCWCCO where keobv1='WA-001' and kefaci='006' and kepctp=1

получаю ошибку:
An error occurred when executing the SQL command:
select kecdpr,keobv1,keccom ,kefaci,(max(kecdpr) over (partition by kefaci,keccom,keobv1 order by kergdt desc)) as ff from mvxjdta.MCWCCO where k...

[SQL0104] Token MAX was not valid. Valid tokens: (. [SQL State=42601, DB Errorcode=-104]

не могу понять почему?

Mark Barinstein,
скобки убирала

Версия и платформа db2 - v7R1 AS400

Mark Barinstein,
спасибо