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.

Table 1. Java data types and their equivalent InfoSphere DataStage data types
Java data type InfoSphere DataStage data type
Note: only applicable for JavaBeans or UDF case
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