Advantage CA-Earl Sort/print fields in descending order

Products

• Earl

Issue/Introduction

Trying to print a report in descending order on create date last user date.

 

Environment

z/os

Resolution

By default, Advantage CA-Earl sorts in ascending order of the standard EBCDIC collating sequence. To sort in descending order, simply add the reserved word DOWN following the sort field name.

Example:
REPORT 'LIST OF EMPLOYEES BY DEPT'
SELECT DEPT NOT = 'AB7'
CONTROL DEPT EMPNO DOWN
PRINT DEPT EMPNO