Index example: Ordering with a unique-weight sort sequence table

 

Ordering with 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)

The system can only use index UNQIX.

 

Parent topic:

Examples of indexes