Problem reading DB2 character for bit data column
Posted: Thu Jul 24, 2008 4:29 pm
Hi,
I have to retreive the content of two DB2 columns that are produced by the IBM DPROP utility. These columns are declared as:
CHARACTER(10) for bit data
with content looking like this from Quest: x'0000208E216190000000'.
What I have to do is basic. In the case that the source record does not satisfy the business rules, I just have to move the entire source record into a reject table that has the same physical structure as the source. What combination of data type and convertion (if necessary) should I use to be able to read and reinsert into a similar DB2 column. I have try a couple of combination but no success so far.
Thanks.
I have to retreive the content of two DB2 columns that are produced by the IBM DPROP utility. These columns are declared as:
CHARACTER(10) for bit data
with content looking like this from Quest: x'0000208E216190000000'.
What I have to do is basic. In the case that the source record does not satisfy the business rules, I just have to move the entire source record into a reject table that has the same physical structure as the source. What combination of data type and convertion (if necessary) should I use to be able to read and reinsert into a similar DB2 column. I have try a couple of combination but no success so far.
Thanks.