Your reply does not help to clarify my original question. Your question
seems to need its own thread.

Thanks,

Kevin Knaus

-----Original Message-----
From: Sharma Om
[mailto:db2udbdba-ezmlmshield-x16591187.[Email address protected]
Sent: Tuesday, August 30, 2005 10:21 AM
To: LazyDBA Discussion
Subject: RE: bitmap data, setting and using

Hi,
When inserting into the txn_sign table the signature column,
which
is defined as VARCHAR(2048) FOR BIT DATA, Length of the signature is
189
bytes, when we select from command line I get back the result set from
the
signature column with correct size(189 bytes) but when same select is
through the application(Using Jave and app. driver over jdbc) we are
getting
result set back with different size(311 bytes). Here is some
detail........
Any suggestion:


Laurel, DAOGeneralTxnSign.select key: 3304

Laurel, DAOGeneralTxnSign.select agent: 1 signature length: 189

Laurel, DAOGeneralTxnSign.insert before insert agent: 1 signature
length: 189

INSERT: INSERT INTO txn_sign (txn_sign_key, transaction_key, agent_key,
signature) VALUES (?, ?, ?, ?) [1505, 3404, 1, D'1oT?o-a?8uxT
e,&wo<?e?iiHa?o*?Eu2?8aS?''uiR[Ms*e'a 5Oy- U\
[Email address protected]

Laurel, DAOGeneralTxnSign.insert key: 1505

Laurel, DAOGeneralTxnSign.insert mainKey: 3304

Laurel, DAOGeneralTxnSign.insert now selecting it back from db after
save

Laurel, DAOGeneralTxnSign.select key: 3304

SELECT txn_sign.txn_sign_key, txn_sign.agent_key, txn_sign.signature
FROM
txn_sign WHERE txn_sign.transaction_key = ? ORDER BY
txn_sign.txn_sign_key
DESC [3304]

Laurel, DAOGeneralTxnSign.select agent: 1 signature length: 311

Thanks
Om

-----Original Message-----
From: Kevin Knaus
[mailto:db2udbdba-ezmlmshield-x52623039.[Email address protected]
Sent: Tuesday, August 30, 2005 11:07 AM
To: LazyDBA Discussion
Subject: bitmap data, setting and using


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


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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