- HOST.
- The collation is ASCII for configurations other than an IBM mainframe-attached host.
Example: Setting a Session to Use the ASCII Collation Sequence
A session can be set to ASCII collation as follows.
SET SESSION COLLATION ASCII;
Example: Effect of the ASCII Collation Sequence on SQL Report Output
The session collation is set to ASCII. Assuming that job_rept contains alphanumeric data, a SELECT that requests a sorted return, as follows.
SELECT emp_no, jobid FROM job_rept ORDER BY job_id;
This request produces the following report, sorting job_id in ascending order.
EmpNo JobId ------ -------- 10201 1001-AP2 10201 1032-AR3 10201 1031-AR2 10004 ENG-0002 10016 ENG-0002 10004 ENG-0003 10003 OE1-0001 10001 PAY-0002