Explore the datatype to catalog datatype mappings available for the datasource.
-
Default mapping
The tables lists the mapping from datatype to catalog datatype, making data management simpler and more organized.
Table 1. Datatype Catalog datatype bigint integer binary blob blob blob clob string varchar() for bit data string char string date date decimal decimal double decimal float double integer integer varchar string numeric decimal real decimal smallint integer time time timestamp datetime timestamp with time zone datetime varbinary blob -
Advanced connectivity bundle mapping
The mapping from datatype to catalog datatype makes data management simpler and more organized when advanced connector bundle is used. For configuration details, refer Advanced connector bundle.
Datatype Catalog datatype BIGINT integer BINARY blob BINARY LARGE OBJECT blob BINARY VARYING blob BLOB blob BOOLEAN boolean CHAR string CHAR FOR BIT DATA string CHAR VARYING string CHAR() FOR BIT DATA string CHARACTER string CHARACTER LARGE OBJECT string CHARACTER VARYING string CLOB string DATALINK string DATE date DB2SECURITYLABEL string DBCLOB string DEC decimal DECFLOAT decimal DECIMAL decimal DOUBLE double DOUBLE PRECISION double FLOAT double GRAPHIC string INT integer INTEGER integer LONG VARCHAR string LONG VARCHAR FOR BIT DATA string LONG VARGRAPHIC string NATIONAL CHAR string NATIONAL CHAR VARYING string NATIONAL CHARACTER string NATIONAL CHARACTER LARGE OBJECT string NATIONAL CHARACTER VARYING string NATIONAL LARGE OBJECT string NCHAR string NCHAR LARGE OBJECT string NCHAR VARYING string NCLOB string NUM decimal NUMBER decimal NUMERIC decimal NVARCHAR string REAL decimal SMALLINT integer TIME time TIMESTAMP datetime VARBINARY blob VARCHAR string VARCHAR FOR BIT DATA string VARCHAR() FOR BIT DATA string VARCHAR2 string VARGRAPHIC string XML string