SPSS Incorrectly Displaying CHAR

78 Views Asked by At

I have a DB2 database connected to SPSS Modeler v.17. Currently most of the tables in DB2 use a unique identifier column that is the CHAR(16) FOR BIT DATA type. This column displays fine in DB2, but when I query the data from within SPSS the values are just displayed as small squares and other unrecognizable shapes. I am thinking that SPSS cannot read the CHAR(16) FOR BIT DATA in its current setup, so my question is how do you get SPSS to display CHAR(16) FOR BIT DATA correctly?

0

There are 0 best solutions below