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?
I have exported a survey to excel and have answers to these questions. I would like to rate each answer on a point scale in the imported spreadsheet inside SPSS and total up the points for each person who answered the survey questions and make a few graphs. Thanks for the help.