Index example: Ordering with no sort sequence table

Ordering with no sort sequence table (SRTSEQ(*HEX)).

  SELECT * FROM STAFF
   WHERE JOB = 'MGR'
   ORDER BY JOB

When using the OPNQRYF command, specify:

OPNQRYF FILE((STAFF))
   QRYSLT('JOB *EQ ''MGR''') 
   KEYFLD(JOB)
   SRTSEQ(*HEX)

DB2 UDB for AS/400 could only use index HEXIX.