Try to use the same data length when comparing a fixed-length character string column value to a host variable or constant value. DB2 UDB for AS/400 does not use an index if the constant value or host variable is longer than the column length. For example, EMPNO is CHAR(6) and DEPTNO is CHAR(3). For example, when using SQL, specify the following:
... WHERE EMPNO > '000300' AND
DEPTNO < 'E20'
instead of
... WHERE EMPNO > '000300 ' AND
DEPTNO < 'E20 '
When using the OPNQRYF command, specify:
... QRYSLT('EMPNO *GT "000300" *AND DEPTNO *LT "E20"')
instead of
... QRYSLT('EMPNO *GT "000300" *AND DEPTNO *LT "E20"')