RE: order by rrn, or lifo?

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

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.