Page 1 of 1

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

PostPosted: Wed Aug 03, 2016 4:34 pm
by 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.

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

PostPosted: Thu Aug 25, 2016 10:34 pm
by 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