How to convert 'FOR BIT DATA'field to readable format?

[ATUL3088]

Hi All

I am trying to unload a table into a mainframe file. The table structure contains a field with datatype CHAR(13) FOR BIT DATA NOT NULL.

Please guide how to convert this field in to a readable field in the file. Thanks in advance for your help.

[alexm]

Hi,

(unless you have an (additional) codepage/CCSID issue with this) there's no way to convert a FOR BIT DATA column into a "readable format", because you need the information what the "unreadable" information represents. A column "FOR BIT DATA" contains a series of bit characters; they can represent characters, numbers, or both, a GIF picture, a PDF document - you name it.

Regards,
alexm