next up previous 222
Next: Selecting subsets from a catalogue
Up: CURSA Catalogue and Table Manipulation Applications
Previous: Copying a catalogue


Sorting a catalogue

To sort a catalogue into ascending or descending order on some (numeric) column type:

catsort

Note that catsort generates a new sorted catalogue; it does not overwrite the existing catalogue. The amount of textual information written to the output catalogue is controlled using the command line mechanism described in Section [*]. You then answer the series of prompts described below. In these descriptions the prompts are identified by the corresponding ADAM parameter name, which appears at the start of the prompt line.

CATIN
Enter the name of the input catalogue.

CATOUT
Enter the name of the output catalogue.

FNAME
Enter the name of the column on which the output catalogue is to be sorted. Catalogues can be sorted on columns of any of the numeric data types. They should not be sorted on columns of data type CHARACTER or LOGICAL.

ORDER
(default = `ASCENDING') Specify the order required for the output catalogue. The alternatives available are `ASCENDING' or `DESCENDING'. Abbreviations down to and including `A' or `D' are permitted.

If a catalogue is sorted on a column which contains null values then the rows for which the column is null will appear after all the rows with a valid value. The order of such rows is unpredictable.



next up previous 222
Next: Selecting subsets from a catalogue
Up: CURSA Catalogue and Table Manipulation Applications
Previous: Copying a catalogue

CURSA Catalogue and Table Manipulation Applications
Starlink User Note 190
A.C. Davenhall
4th November 2001
E-mail:starlink@jiscmail.ac.uk

Copyright © 2001 Council for the Central Laboratory of the Research Councils