All,

When defining a column as a CHAR (10) FOR BIT DATA, I want to use it by
having each bit position represent a particular thing. Then I want to
use it to select rows from the table where certain bits are set.

Is that the normal use of "FOR BIT DATA"? If so, how do I set the
correct bits and how do I reference bit positions in a query where
clause?

If this is not the intended purpose of "FOR BIT DATA", what is the
intended purpose?

In general I am trying to use the bit data to work with approximately
1000 different objects, so I would need up to 1000 bits.

Thanks

Kevin Knaus

DB2 & UDB email list listserv db2-l LazyDBA home page