How to handle "VARCHAR FOR BIT DATA" datatype from IBM DB2 in Qlik Sense?

[Anonymous]

Hi All,

I have a table with some fields defined as "VARCHAR FOR BIT DATA" datatype in IBM DB2 database. When I load the data into Qlik Sense and display these fields' data, "system.byte[]" is being displayed. Please find the screenshot for the same. Any help to handle this data would be appreciated.

Thanks in Advance,

Mohammad Sajjad Ali

[petter]

My choice would be to first try to convert or cast the data in the SQL SELECT for the DB2. Try to follow one of the advice from this article: https://bytes.com/topic/db2/answers/182124-function-convert-bit-data-column-string

[Anonymous]

Thanks a lot Petter. I have tried casting the data using "HEX" function for all "VARCHAR FOR BIT DATA" datatype fields in the SELECT statement. And this works.