Re: Question on selecting rows in table

JohnO wrote:

> I need to select portions of a table for parallel processing, without
> relying on any data column in the table. Essentially, I need to create two
> (or more) datasets to have parallel program threads fetch against to run a
> process on every row in the table, while guaranteeing that no row is
> processed twice, and no row is missed. Is there a column like "ROWID", but
> numbered so I can do math on it, or a function of ROWID that will allow a
> select conditional to select mutually exclusive, collectively exhaustive
> portions of the table?
>
> Thanks!

I have a real problem when people write "I need to" followed by a description of what they "WANT" to do.

I would suggest that you restate the request as a business problem such as:

1. I am doing such-and-such and it is too slow. or
2. I am engaged in a pointless academic exercise. or
3. ....

Because I take strong exception with the thought that you actually "NEED" to something in a specific way. Unless, of course, you are in a class and your instructor has made this a requirement and you want someone else to do your homework for you.

Daniel Morgan Received on Mon Nov 04 2002 - 14:20:40 CST