RE: order by rrn, or lifo?

Thanks to everyone who helped...  I worked with steve's example first...
And this file (should...) be safe, since I never delete records from this
file... I just change a status... but your point is well taken..

I decided to qualify my library names...  since i'm running this through a
jdbc connection, and I get the warm fuzzies knowing I'm reading the file,
from the correct library, I just havn't developed that trust relationship
yet, through a connection pool..

select rrn(mmcust120.acom) as sortorder ,mmcust120.acom.*  from
mmcust120.acom 
         where ack855 < 0 
                order by sortorder desc

tim

> -----Original Message-----
> From: DeLong, Eric [SMTP:EDeLong@xxxxxxxxxxxxxxx]
> Sent: Wednesday, August 06, 2003 1:26 PM
> To:   'Midrange Systems Technical Discussion'
> Subject:      RE: order by rrn, or lifo?
> 
> Tim,
> 
> Ordering on RRN is possible, but it does not guarantee LIFO.  
> 
> SELECT rrn(DB2FILE), DB2FILE.* FROM DB2FILE ORDER BY 1 DESC
> 
> Several options, like "reuse deleted records", or even RGZPFM KEYFILE()
> can
> cause RRN to lose FIFO or LIFO ordering.  
> 
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-898-7863 or ext. 1863
> 
> 
> 
> -----Original Message-----
> From: Hatzenbeler, Tim [mailto:thatzenbeler@xxxxxxxxxxxxx]
> Sent: Wednesday, August 06, 2003 2:58 PM
> To: 'Midrange Systems Technical Discussion'
> Subject: order by rrn, or lifo?
> 
> 
> Is it possible on a sql select statement, to order my results by the
> latest
> record in the file to the oldest?  without using a date field?  I would
> like
> to order by the rrn, highest to lowest...
> 
> thanks, tim
> 
> This e-mail message, including any attachments, is for the sole use of the
> intended recipient(s) and may contain confidential or privileged
> information.  Any unauthorized review, use, disclosure or distribution is
> prohibited.  If you are not the intended recipient, please contact the
> sender by reply e-mail and destroy the message.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.