I'm trying to use Query to search for a value on an Omnidex (IMSAM) chain.
Query, keeps trying to use a serial read and will not use the TPI index.  Is
there any way to force using the index, via a command, or a structuring of
the find statement.  See details below.

Mike Berkowitz
Guess? Inc.

:QUERY
HP32216D.03.20  QUERY/NM  FRI, JUN 22, 2001,  9:18 AM
COPYRIGHT HEWLETT-PACKARD CO. 1976

>B=AMSAUX
PASSWORD = >>
MODE = >>1
>S=INV-MAST
>FO INV-MAST


DATA BASE: AMSAUX                       FRI, JUN 22, 2001,  9:18 AM


DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000


SET NAME:
   INV-MAST,DETAIL

      ITEMS:
         INV-NO,               X6            <<SEARCH ITEM>>
         CUST/LOG,             X12           <<SEARCH ITEM>>
         CUST-NO,              X6            <<SEARCH ITEM>>
         INV-DATE,             X6
         AS-OF-DATE,           X6
         DUE-DATE,             X6
         SHIP-VIA,             X12
         INV-GROUP,            X2
         SEQ-NO,               J1
         WEIGHT,               J2
         BOXES,                J1
         MERCH-AMT,            J2
         DISC-AMT,             J2
         FREIGHT-AMT,          J2
         INS-AMT,              J2
         MISC-AMT,             J2
         TAX-AMT,              J2
         TOT-AMT,              J2
         INV-QTY,              J2
         REC-TYPE,             X2
         FILLER20,             X20

      TPI INDEXES:
         INV-DATE,             G6
         CUST/INV-DATE,        G12
         LOG-NO,               G6

      CAPACITY: 242648          ENTRIES: 235259
   MAXIMUM CAPACITY: 10006976   INITIAL CAP.: 202216     INCREMENT: 10108



>F INV-DATE=911210
USING SERIAL READ

< CONTROL Y >

0 ENTRIES HAVE QUALIFIED, DO YOU WANT TO CONTINUE SEARCHING?
>>NO
0  ENTRIES QUALIFIED
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *