Data types
Source or target databases, or Hadoop clusters, might not support all the data types that InfoSphere® DataStage® supports.
Teradata V2R5.1, V2R6.0, and V2R6.1 do not support 64-bit integers (BIGINTs), so any InfoSphere DataStage functions that produce 64-bit integer results cannot be pushed into Teradata sources or targets.
The maximum precision of the DECIMAL type is 18 digits for Teradata V2R5.1, V2R6.0 and V2R6.1, and 38 digits for Teradata V12.
The Db2® 9.1 TIME data type does not support fractional digits or microseconds.
The following table lists transformer data types and the corresponding data type for each database and for JAQL queries.
| Transformer data type | Teradata data type | IBM® Db2 data type | Netezza data type | Oracle data type | JAQL data type |
|---|---|---|---|---|---|
| BIGINT | BIGINT | BIGINT | BIGINT | NUMBER(19) | LONG |
| BINARY | BYTE | CHARACTER | Not supported | RAW | BINARY |
| BIT | SMALLINT | SMALLINT | BOOLEAN | NUMBER(5) | BOOLEAN |
| CHAR | CHAR | CHARACTER | CHAR | CHAR | STRING |
| DATE | DATE | DATE | DATE | DATE | STRING |
| DECIMAL | DECIMAL | DECIMAL | NUMERIC or DECIMAL | NUMBER | DOUBLE |
| DOUBLE | FLOAT | DOUBLE | DOUBLE PRECISION or FLOAT(15) | BINARY_DOUBLE | DOUBLE |
| FLOAT | FLOAT | DOUBLE | FLOAT | BINARY_FLOAT | DOUBLE |
| INTEGER | INTEGER | INTEGER | INTEGER | NUMBER(10) | LONG |
| LONGVARBINARY | BLOB | BLOB | Not supported | BLOB | BINARY |
| LONGVARCHAR | CLOB | CLOB | NVARCHAR | CLOB | STRING |
| NUMERIC | DECIMAL | DECIMAL | NUMERIC | NUMBER | DOUBLE |
| REAL | FLOAT | REAL | REAL or FLOAT(6) | BINARY_FLOAT | DOUBLE |
| SMALLINT | SMALLINT | SMALLINT | SMALLINT | NUMBER(5) | LONG |
| TIME | TIME | TIME | TIME | INTERVAL DAY(2) TO SECOND(0) | STRING |
| TIMESTAMP | TIMESTAMP | TIMESTAMP | TIMESTAMP | TIMESTAMP | STRING |
| TINYINT | SMALLINT | SMALLINT | BYTEINT | NUMBER(5) | LONG |
| VARBINARY | VARBYTE | VARCHAR | Not supported | RAW | BINARY |
| VARCHAR | VARCHAR | VARCHAR | NVARCHAR | VARCHAR2 | STRING |
| WCHAR | CHAR | GRAPHIC | Not supported | NCHAR | Not supported |
| WLONGVARCHAR | CLOB | LONG VARGRAPHIC | Not supported | NCLOB | Not supported |
| WVARCHAR | VARCHAR | VARGRAPHIC | Not supported | NVARCHAR2 | Not supported |