HP3000-L Archives

July 1999, Week 3

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Richard Gambrell <[log in to unmask]>
Reply To:
Richard Gambrell <[log in to unmask]>
Date:
Mon, 19 Jul 1999 17:29:42 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (33 lines)
I don't believe relational databases preserve any order of records in
loading data.  If you want a specific order, then you have to "order by"
the appropriate data columns in retrieval.

Richard G

Henning wrote:
>
> Does anyone know how I can prevent Allbase from dis-sorting my
> sorted data when loading from a flat-file ??
>
> It seems to me there is some sort of wraparound which causes the
> disorder. When I load just a few data, the sorting-order is
> intact but as soon as I load a huge amount of data, the sorting-
> order gets lost somewhere during loading. Is it a matter of
> table-size ?
>
> tia,
>
> Henning

--
Richard Gambrell
Database Administrator and Consultant to Computing Services at
** UTC business:
  University of Tennessee at Chattanooga
  113 Hunter Hall, Dept. 4454
  615 McCallie Ave., Chattanooga, TN 37403-2598
  fax: 423-755-4025
  phone: 423-755-4551          email: [log in to unmask]
** other business or private:
  voice mail/phone: 423-874-0261  email: [log in to unmask]

ATOM RSS1 RSS2