RE: DB2 Question

The RRN idea doesn't even work on the iSeries.

You'd get nothing if the first 100 records happen to be deleted.

The only way to do this is a Pual already posted:

select * from table
  (select * from
    (select * from table where...
       order by column fetch first 75 rows only) as t1
    order by column desc fetch first 25 rows only) as t2
order by column

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx 
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden 
H. Leverich
Sent: Wednesday, May 31, 2006 1:59 PM
To: Java Programming on and around the iSeries / AS400
Subject: RE: DB2 Question

The RRN() concept wouldn't make sense anywhere but iSeries. 
On the other
platforms you'd have to use the top xxx with an order by.

-Walden

-- 
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)

-- 
This is the Java Programming on and around the iSeries / 
AS400 (JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.