Index example: Grouping with no sort sequence table

 

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

  SELECT JOB FROM STAFF    GROUP BY JOB

When using the OPNQRYF command, specify:

OPNQRYF FILE((STAFF)) FORMAT(FORMAT2)
   GRPFLD((JOB)) 
   SRTSEQ(*HEX) 

The system can use either index HEXIX or index UNQIX.

 

Parent topic:

Examples of indexes