var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to convert 'FOR BIT DATA 'field to readable format?
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.
Try to convert such a value to its string representation like this:
Originally Posted by
I am getting following error:
SQLCODE = -110, ERROR: INVALID HEXADECIMAL CONSTANT BEGINNING
The value in the field seems to be encrypted, so i am getting junk value on unloading the table.
Which query returns such an error?
This one above works well on my zDB2.
What's your zDB2 version?
The CHAR FOR BIT DATA value can't be "encrypted". This value is simply a set of bytes, and if you want to have in a "readable" form, you can use hex function to get the string representation of such a set of bytes.
I am running SELECT query on the table using HEX display and it is throwing the above error.
The DB2 version is 10.