Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.