Data type conversions from Java to DataStage data types (Java Integration stage)
In an output link where DataStage® columns are set from the Java™ types produced by the Java Integration stage, the Java Integration stage converts Java data types to InfoSphere® DataStage data types.
Likewise, after metadata is imported through the Java Integration stage, the Java data types are converted to InfoSphere DataStage data types. The following table shows the mapping rules between Java data types and InfoSphere DataStage data types.
| Java data type | InfoSphere DataStage data type |
|---|---|
| boolean/java.lang.Boolean Note: only applicable
for JavaBeans or UDF case
|
Bit |
| short/java.lang.Short | TinyInt |
| int/java.lang.Integer | SmallInt or Bit |
| long/java.lang.Long | Integer |
| java.math.BigInteger | BigInt |
| float/java.lang.Float | Real or Float |
| double/java.lang.Double | Double |
| byte[] | Binary or VarBinary or LongVarBinary |
| java.lang.String | Char or VarChar or LongVarChar or NChar or NVarChar or LongNVarChar |
| java.sql.Date | Date |
| java.sql.Time | Time |
| java.sql.Timestamp | TimeStamp |
| java.math.BigDecimal | Decimal or Numeric |