Index example: Greater than selection with a unique-weight sort sequence table
Greater than selection with a unique-weight sort sequence table (SRTSEQ(*LANGIDUNQ) LANGID(ENU)).
SELECT * FROM STAFF WHERE JOB > 'MGR'When using the OPNQRYF command, specify:
OPNQRYF FILE((STAFF)) QRYSLT('JOB *GT ''MGR''') SRTSEQ(*LANGIDUNQ) LANGID(ENU)The system can only use index UNQIX.
Parent topic:
Examples of indexes