17.00 - Example: Effect of the EBCDIC Collation Sequence on SQL Report Output - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

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