Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mdsajjadali
New Contributor

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

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

System.Byte[].PNG

2 Replies
MVP
MVP

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

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

mdsajjadali
New Contributor

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

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.

Community Browser