Without a SORT clause or a SAS BY statement, the data order is determined by the Native Key for the CA-DATACOM/DB table (or by the Default Key specified in the access or view descriptor). A SAS BY ...
A SAS BY statement automatically issues a SORT clause to ADABAS. If a view descriptor already contains a SORT clause, the BY statement overrides the sort for that program. An exception is when the SAS ...