Page 1 of 1

column sqltype - bit

Posted: Sun Dec 04, 2005 11:24 am
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.

Posted: Sun Dec 04, 2005 1:27 pm
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.