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)

DB2 UDB for AS/400 could only use index UNQIX.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]