If the descending option is specified for the query in Example: Setting a Session to Use the EBCDIC Collation Sequence in place of the default sort direction, which is ascending, the following report is produced, sorting job_id in descending EBCDIC order.
SELECT emp_no, job_id FROM job_rept ORDER BY job_id DESC; emp_no job_id ------ -------- 10201 1031-AR2 10201 1032-AR3 10201 1001-AP2 10001 PAY-0002 10003 OE1-0001 10004 ENG-0003 10004 ENG-0002 10016 ENG-0002