Convert Qualify Rank from Teradata to DB2

From: Michael L. <mleung63_at_yahoo.com>
Date: 10 Apr 2004 06:16:41 -0700
Message-ID: <dad32198.0404100516.1a2f753d@posting.google.com>

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_at_mantech.com Received on Sat Apr 10 2004 - 08:16:41 CDT