SORT.SUP

The SORT.SUP keyword suppresses the default sort by record id in the SHOW command.

Format

SORT.SUP

The default action of the SHOW command if no sort clause is present is to show records sorted by record id. The SORT.SUP keyword suppresses this sort. It is useful where a sorted select list is being used to determine the records to be processed.

The keyword is ignored if the query includes a sort clause.

Example

SELECT SALES BY CUSTOMER

SHOW SALES SORT.SUP

This command displays records in customer order.