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 type mappings applicable when working with an IBM DB2 database.
IBM DB2 Database Type |
Spotfire Data Type |
Supported |
CHAR () FOR BIT DATA |
Binary |
Yes |
LONG VARCHAR FOR BIT DATA |
Binary |
Yes |
VARCHAR () FOR BIT DATA |
Binary |
Yes |
DATA |
Date |
Yes |
TIME |
Time |
Yes |
TIMESTAMP |
DateTime |
Yes |
DECIMAL |
s >
26 || p > 28 =>
Real/Double |
Yes |
DOUBLE |
Real/Double |
Yes |
SMALLINT |
Integer/Int |
Yes |
INTEGER |
Integer/Int |
Yes |
BIGINT |
LongInteger/Long |
Yes |
REAL |
SingleReal/Float |
Yes |
CHAR |
String |
Yes |
LONG VARCHAR |
String |
Yes |
VARCHAR |
String |
Yes |
BLOB |
No |
|
CLOB |
No |
|
DBCLOB |
No |
|
DECFLOAT |
|
No |
GRAPHIC |
|
No |
LONG VARGRAPHIC |
|
No |
VARGRAPHIC |
|
No |
BOOLEAN |
|
No |
XML |
|
No |
See also: