Path: utzoo!attcan!uunet!husc6!yale!cs.utexas.edu!jarvis.csri.toronto.edu!utgpu!romwa
From: romwa@gpu.utcs.utoronto.ca (Royal Ontario Museum)
Newsgroups: comp.databases
Subject: Re: Informix isql
Keywords: order by, select, entry form
Message-ID: <1990Feb16.142347.17145@gpu.utcs.utoronto.ca>
Date: 16 Feb 90 14:23:47 GMT
References: <6548@uhccux.uhcc.hawaii.edu> <1990Feb11.084522.12120@halexii.uucp>
Organization: UTCS Public Access
Lines: 24

In article <1990Feb11.084522.12120@halexii.uucp> greg@halexii.UUCP (Gregory F. Hogg) writes:
>In article <6548@uhccux.uhcc.hawaii.edu> richardj@uhccux.UUCP (Richard Jablonka) writes:
>>
>>I want to SORT an informix table.  I only need to do it once.  The problem is 
>>making the names come up in the right order in an entry form.   Unfortunately
>
>	As fas as I know there is no way todo what you want in
>INFORMIX-SQL. The best I have been able to do is to unload the table
>ordered the way you want and then reload it.  This way the records are
>in the dbtable allready ordered.
>
There is an index facility in isql thatputs the records in sorted
order on the disk.  I'm not sure of how m{uch overhead this puts on
the database, but it may solve your problem.

Without the 4GL this is the only way I know to do this.

Mark T. Dornfeld
Royal Ontario Museum
100 Queens Park
Toronto, Ontario, CANADA
M5S 2C6

mark@utgpu!rom      - or -     romwa@utgpu