column sqltype - bit

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
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

column sqltype - bit

Post by ds_is_fun »

I have an EBCDIC/Binary data. I have defined column layout. For the column type bit(8) the length is 1. When I try to view the data it seems to be having a problem with that column.
Additional info -
1. ASCII file on UNIX machine
2. Fixed lengths columns.
3. No delimiters.
Pl. help.
Thank you.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

bit(8) is an eight-bit, or one-byte, quantity. It's a binary value - if the bits don't assemble into the representation of a viewable (printable) character then the View Data mechanism has no hope of displaying it.

You could try temporarily changing the data type to uint8, which is a value from 0 through 255, from which you can discern the bit pattern.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply