Convert Qualify Rank from Teradata to DB2

[Michael L.]

hi everyone,


It is relatively easy to translate RANK() from teradata to DB2, but I
get to a glitch when I realize what Qualify RANK does. I know that
there are a lot of experienced DB2 professionals out there, so I am
hoping that someone may be able to give me a clue.

Any suggestions on how to convert Qualify RANK from Teradata to DB2?


Thanks in advance.

Michael


p.s. I will check here later, but if you like, you can also contact me
through mleung@mantech. com

[Serge Rielau]

Re: Convert Qualify Rank from Teradata to DB2


Can you give a quick rundown of what qualify rank does?

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab