Re: Need help to canvert oracle funciton last in db2

LAST is supported on DB2 9.5.
http://publib.boulder.ibm.com/infoce.../r0023461.html
Which version are you on?
(Sorry if I keep asking depite us talking alot.. my usenet interaction
is state-less ;-)

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

I have at home 9.5c but at work db2 v8.2 oz

Serge Rielau wrote:--
Message posted via http://www.dbmonster.com

lenygold via DBMonster.com wrote:I wasn't aware there is a DB2 V8.2 for zOS...

Anyway your options on DB2 8 zOS are very limited (non existent?) w.r.t.
OLAP.
So you need to investigate joins....

Cheers
Serge



--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab