If the same session from Example: Effect of the ASCII Collation Sequence on SQL Report Output is then set to EBCDIC collation as follows.
SET SESSION COLLATION EBCDIC;
The same SQL request produces the following report, sorting job_id in the ascending order defined for EBCDIC.
EmpNo JobId ------ -------- 10004 ENG-000 10016 ENG-0002 10004 ENG-0003 10003 OE1-0001 10001 PAY-0002 10201 1001-AP2 10201 1032-AR3 10201 1031-AR2