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) 

DB2 UDB for AS/400 could use either index HEXIX or index UNQIX.