Re: Problem with SQL

Quoting John Baker Depot Sys Mgt Br... > > Everything works as it should, *except* that the records are not being > stored in the .dat files in the order in which they were entered! > > Our platform is a Unisys 5000/80 running UNIX V.3.2. A solution or > workaround would be most helpful. HELP! > When you select data from your table, do an "ORDER BY ROWID". That will work until you start removing old records and inserting new ones. The slots where the old records have been deleted will be filled before expanding the size of the table. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.2 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com