You need to check the application code , how it is fetching the bit data
...
For bit data jdbc equivalent is getBytes() and then you need to parse it
to string.. Something like this...

rs1 = stmt1.executeQuery(strselect);

while (rs1.next())
{

System.out.println(rs1.getInt(1) + " | " + new String(rs1.getBytes(2)));
}

Where column two in table is defined as varchar (30) for bit data.

Amit Rai.

-----Original Message-----
From: Sharma Om
[mailto:db2udbdba-ezmlmshield-x16591187.[Email address protected]
Sent: Tuesday, August 30, 2005 11: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



-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication. It is intended solely for the use of the designated recipient(s). If this communication is received in error, please contact the sender and delete this communication.
===========================================================================================

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