When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with an IBM DB2 database.
IBM DB2 Data Type |
Spotfire Data Type |
CHAR () FOR BIT DATA |
Binary |
LONG VARCHAR FOR BIT DATA |
Binary |
VARCHAR () FOR BIT DATA |
Binary |
DATA |
Date |
TIMESTAMP |
DateTime |
INTEGER |
Integer/Int |
SMALLINT |
Integer/Int |
BIGINT |
LongInteger/Long |
DOUBLE |
Real/Double |
DECIMAL |
s >
26 || p > 28 =>
Real/Double |
REAL |
SingleReal/Float |
CHAR |
String |
LONG VARCHAR |
String |
VARCHAR |
String |
TIME |
Time |
Any other data types are not supported.