SORT.SUP

SORT.SUP

Top  Previous  Next

 

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.