By convention, if not by definition, SQL repositories have no concept of
ordering. The only ordering is imposed at query time by the ORDER BY
clause. Also by definition, a deleted row is completely gone from the
table. (It may be recovered from the journal.)
The concept that records have a "place" in a file (a RRN, that is) is a
legacy from older definitions of the System38-AS400 database and is kept
only for backwards compatibility. Other database software systems have
no concept of relative record number or arrival sequence.
All the modern databases do have a sequential numbering facility. You
can use that to maintain something like arrival sequence. You use a
field (column) to do it.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Kurt Anderson
Sent: Thursday, February 11, 2010 1:55 PM
To: 'Midrange Systems Technical Discussion'
Subject: SQL REUSEDLT
Is there a REUSEDLT(*NO) equivalent in SQL's Create Table? (I didn't
have any luck in finding one on the web.)
We're at v5r4.
Thanks,
Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems
--
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.
midrange.com
