Re: C-ISAM switching indexes... Needhelp!

> > Thanks for the answer dave. Unfortunately my simplistic example isn't > a true reflection of my real world application. I have already used 8 > keys to represent this index with a total of 116 bytes in length. If I > add the unique index keys to the non-unique index then I will require > another three keys and room for 68 bytes. This unfortunately surpasses > the C-ISAM limitation of 120 bytes per index and I think 8 keys per > index. > > Walter Walter, There is a way round this. Create a second unique index consisting of a serial number. Then combine this with your duplicate index to make a third index which gets round the space problem. Then you do a isstart on the original primary index, pick up the values of the serial number and other attributes of the third index and do an isstart with these values. Hope this helps. Cheers - Jim -------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 358-5911 (Work) Address: 1700 S. Amphlett Blvd. (415) 882-9728 (Home) San Mateo, CA 94402 Fax: (415) 571-6429 --------------------------------------------------------------------