Index example: Ordering with ALWCPYDTA(*OPTIMIZE) and a unique-weight sort sequence table

Ordering with ALWCPYDTA(*OPTIMIZE) and a unique-weight sort sequence table (SRTSEQ(*LANGIDUNQ) LANGID(ENU)).

  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(*LANGIDUNQ) LANGID(ENU)
   ALWCPYDTA(*OPTIMIZE)

DB2 UDB for AS/400 could use either index HEXIX or index UNQIX for selection. Ordering would be done during the sort using the *LANGIDUNQ sort sequence table.