... but it is possible to sort with SQL after the relative Record No (if
necessary)
Select ....
From yourTable
Where ...
Order By RRN(YourTable);
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Voris,
John
Sent: Montag, 27. Juli 2020 13:42
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: REUSEDLT(*NO) - what's the point?
Also, SQL SESLECT statements, if their ORDER BY is not down to a granular
level of uniqueness - can give different results because of the Sequence of
the records. There could be applications that have always behaved one way,
and with REUSEDLT(*YES) they behave differently
- John Voris
Philadelphia
-====================================-
message: 4
date: Mon, 27 Jul 2020 11:08:56 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: RE: REUSEDLT(*NO) - what's the point?
I've actually worked on such a bill of materials application. And it if got
clobbered the vendor had a utility. Something about rebuilding the chain
chase sequence comes to mind.
Rob Berendt
--
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vernon
Hamberg
Sent: Saturday, July 25, 2020 6:32 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: REUSEDLT(*NO) - what's the point?
Patrik
One cannot safely assume that the arrival order does not matter. The chances
are that the technique of linked lists using RRNs is not in use, but you
can't guarantee it. That used to be used for bills-of-materials in ERP
products.
So it is still important to check before setting REUSEDLT(*YES).
what could be the reason for CRTPF and CHGPF having a default setting of
REUSEDLT(*NO)?
Thanks for all of your valuable feedback. All in all, it seems to be
mostly a leftover from ancient times, so I guess it's helpful to always
switch to REUSEDLT(*YES) nowadays, even with older machines.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
