Re: Need help to canvert oracle funciton last in db2

[Serge Rielau]

LAST is supported on DB2 9.5.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.sql.ref.doc/doc/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

[lenygold via DBMonster.com]

Re: Need help to canvert oracle funciton last in db2

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

Serge Rielau wrote:

>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
>

--
Message posted via http://www.dbmonster.com

[Serge Rielau]

Re: Need help to canvert oracle funciton last in db2

lenygold via DBMonster.com wrote:

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

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