Problem reading DB2 character for bit data column

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Salegueule
Participant
Posts: 35
Joined: Fri May 21, 2004 4:22 pm

Problem reading DB2 character for bit data column

Post by Salegueule »

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.
Post Reply