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?
SPSS Incorrectly Displaying CHAR
92 Views Asked by Eric Crowley At
0
There are 0 best solutions below
Related Questions in SQL
- Can MVC.NET prevent SQL-injection at razor or controller level?
- SQL server not returning all rows
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Creating a parametrized field name for a SELECT clause
- Combine two rows based on common ID
- Column displays each count
- Slick query for one to optional one (zero or one) relationship
- Aggregate and count in PostgreSQL
- MAX and GROUP BY - SQL
- SQL statement for a tricky 2 table query
- How to create nested selects with sql?
- Pull and push data from and into sql databases using Excel VBA without pasting the data in Excel sheets
- Best Practice for adding columns to a Table in Oracle database
- SQL FIFO STACK using two tables
- SQL Query - Order by String (which contains number and chars)
Related Questions in DB2
- How to grant privileges to current user
- Drop DB2 database if exist
- DB2, Hibernate, JPA: Schema does not exist
- Can you check for a DB2 license in C#?
- DB2 Join Query that Maximizes Column
- How to access a Row Type within an Array Type in DB2 SQL PL
- IBM DB2 native encryption applied on live database
- Using an ODBC connection in Access get retrieve data from DB2
- join 2 tables and get some columns from 1st table and max timestamp value from second table
- How to connect to DB2 SQL database with node JS?
- TRANSLATE not working inside XMLAGG
- Cannot initialise HikariCP pooled connection, Failure in loading native library db2jcct2
- published reports don't work - Database logon failed Error
- 1 Working Day Back In SQL DB2
- In java with DB2 parallel process: I got Deadlock Exception :DB2 SQL Error: SQLCODE=-911, SQLSTATE=40001, SQLERRMC=2, DRIVER=3.59.81
Related Questions in SPSS
- Control encoding when parsing SPSS file using package memisc
- Skewness in SPSS - SPSS answers differently in multiple PC
- How can I download SPSS for macbook?
- SPSS Frequency Plot Complication
- How to remove white space from a data frame in R, when importing from SPSS
- Graphs in a loop in SPSS
- conditional filtering in SPSS
- Ctables macro is spss
- SPSS: Replace missing values with date
- Deleting Value Labels in SPSS
- How to Synch SPSS and SQL Data
- SPSS create variable function in R
- Comparing multiple items
- spss significance asterisk (for graphs)
- SPSS: Inconsistent totals due to rounding of numbers
Related Questions in SPSS-MODELER
- Comparing multiple items
- How to set more conditions (targets) in the Time Series Node in SPSS Modeler?
- How to build "if statement" in SPSS Modeler?
- Delete output files from folder SPSS Modeller
- Modify values programmatically SPSS
- SPSS Modeler group by and select top n rows
- stuck in replacing negative values with zero in SPSS Modeler
- How to set an SPSS model nugget to be automatically placed on palette only?
- Automated transfer of files to an SFTP - SPSS Modeler / PS Clem
- Scheduling an IBM SPSS Modeler stream
- How do I deploy my existing SPSS streams takes input from DB using WML in Watson Studio
- How to run a modeler stream from an SPSS Statistics syntax using SPSS's python interpreter
- Aggregate the columns based on a condition in SPSS modeler
- Joining variables with keyvariable in spss
- Running R in SPSS Modeller V17 - Version issues
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?