Greetings, Family.

I have a situation where I need to select a subset of the rows of a
fragmented table - the rows, say, DBSpace#6. If it is fragmented by
expression it's easy; just specify "WHERE <fragment condition>".
Similarly, for any row I randomly select, I can check for the
condition of each fragment in turn until I get a match. But if it
is fragmented by round-robin, how do I select the rows that reside
only in the specified DBSpace? Or if selecting by other means, how
do I retrieve the name of the row's DBSpace?

I have the eerie feeling I have done this before but I can't recall
how. Very frustrating!

My motivation here is to isolate some corruption that may have been
cause by a hardware glitch. I need to prove if it is table-wide or
only in one dbspace.

Thanks much.

+------------ Jacob Salomon JSalomon@bn.com -- -------------- -----+
| Man does not live by words alone, despite the fact that sometimes|
| he has to eat them. |
+------------------------------------------- Adlai Stevenson ------+