You can specify the store order properties while creating a table. Alternatively, the store order properties can be determined by the system. For more information, see
HPE NonStop SQL/MX Release 3.4 Reference Manual. To display the store order properties:
Procedure
-
Select a table in the left pane.
-
In the right pane, click
Store Order.
The following details appear:
-
Position: The position of the column in the key, for the physical file.
-
Column Name: The name of the column (string).
-
Sort Order: The order specified as
Ascending
or
Descending
-
Added By: The property indicates whether the column was added by the system or by the user.