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!
Received on Mon Nov 04 2002 - 13:49:49 CST
