Re: cluster index

Marek Branecki wrote: > > I've got a table, create cluster index on some columns > then declare cursor and browse table with fetch next > and everything is ok, i can see my data in proper order. > > Next I add some rows and when i browse new rows are > at end. I cannot set order declaring cursor because it's > for update. You can execute another "alter index ... to cluster" before declaring the update cursor, but if the where clause on the cursor declare causes informix to use another index though they'll be in a different order. Or you could declare a non-update cursor with an order by then update based on a unique key, but then you won't get the same kind of row locking if that's what you need. Or you can question your need to update in a certain order, but I suppose you've already determined that need otherwise why would you be asking the question. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** anyone elses **** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***