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

 

Grouping with a unique-weight sort sequence table (SRTSEQ(*LANGIDUNQ) LANGID(ENU)).

  SELECT JOB FROM STAFF    GROUP BY JOB

When using the OPNQRYF command, specify:

OPNQRYF FILE((STAFF)) FORMAT(FORMAT2)
   GRPFLD((JOB)) 
   SRTSEQ(*LANGIDUNQ) LANGID(ENU) 

The system can use either index HEXIX or index UNQIX.

 

Parent topic:

Examples of indexes