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



IBM's flagship relational database management system

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

Postby ATUL3088 » Wed Aug 03, 2016 4:34 pm

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.
ATUL3088
 
Posts: 1
Joined: Wed Aug 03, 2016 4:25 pm
Has thanked: 0 time
Been thanked: 0 time

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

 

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

Postby alexm » Thu Aug 25, 2016 10:34 pm

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
User avatar
alexm
 
Posts: 33
Joined: Wed Oct 13, 2010 6:40 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post