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 IBM® DataStage data types.
Likewise, after metadata is imported through the Java Integration stage, the Java data types are converted to IBM DataStage data types. The following table shows the mapping rules between Java data types and IBM DataStage data types.
Java data type | IBM 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 |