I have a BTREE index on an invoice file that indexes all invoices for
all customers by date.

The index is CUSTOMER.DATE and the definition is BY-AL 1 BY-AR 5 where
1 is the customer attribute and 5 is the invoice date attribute.

I want to select all invoices for a range of customers and for a range
of dates.

Does anybody know how to specify the start and end keys for the KEY-
SELECT statement for this multiple range?

On May 25, 9:03 am, k... (AT) calidore (DOT) com wrote:
You don't indicate which multivalue database you are using but in the
case of D3 I don't believe the system B-Tree Indexing handles ranges.
What I have done to select a range of dates was to write a short
program do do the Selects one day at a time using the index and adding
the daily Selects together.
Bob Marik

On May 28, 2:30 pm, bob marik <rma... (AT) mcbaincamera (DOT) com> wrote:
Hi Bob

I Should have mentioned that we use mvbase which does allow index
ranges but the manual doesn't specify how to create and access
multiple key indexes.

Thanks for your input.