Java type to DataStage type mapping with the Operational Decision Manager (ODM) stage
The configuration wizard maps Java™ types that are used by the ruleset parameters to the corresponding column definitions on the links of the stage.
At run time, the connector maps, as necessary, the Java types in OUT and IN_OUT ruleset parameters associated with output links to DataStage® type definitions for the columns on those
links.
The link columns that correspond to int, short, long, double, float, Boolean, byte,
and char Java types are configured with the
Nullable attribute set to No. The columns for the
remaining Java types, including char[] and byte[] types, are
configured with the Nullable attribute set to
Yes.
| Java type | DataStage SQL Type | Length | Scale | Extended |
|---|---|---|---|---|
| short, java.lang.Short | SmallInt | (n/a) | (n/a) | Empty |
| int, java.lang.Integer | Integer | (n/a) | (n/a) | Empty |
| long, java.lang.Long | BigInt | (n/a) | (n/a) | Empty |
| float, java.lang.Float | Float | (n/a) | (n/a) | (n/a) |
| double, java.lang.Double | Double | (n/a) | (n/a) | (n/a) |
| Boolean, java.lang.Boolean | Bit | (n/a) | (n/a) | (n/a) |
| byte, java.lang.Byte | TinyInt | (n/a) | (n/a) | Empty |
| byte[], java.lang.Byte[] | VarBinary | Empty | (n/a) | (n/a) |
| char, java.lang.Character | Char | 1 | (n/a) | Unicode |
| char[], java.lang.Character[] | VarChar | Empty | (n/a) | Unicode |
| java.lang.String | VarChar | Empty | (n/a) | Unicode |
| java.util.Date, java.util.Calendar | Timestamp | (n/a) | (n/a) | Microseconds |
| java.sql.Date | Date | (n/a) | (n/a) | (n/a) |
| java.sql.Time | Time | (n/a) | (n/a) | Microseconds |
| java.sql.Timestamp | Timestamp | (n/a) | (n/a) | Microseconds |
| java.math.BigInteger | BigInt | (n/a) | (n/a) | Empty |
| java.math.BigDecimal | Decimal | 255 | 127 | (n/a) |
The boolean and java.lang.Boolean
Java types can also be mapped to character-based IBM® DataStage data
types Char, NChar, VarChar, LongVarChar, NVarChar, and LongNVarChar. The Boolean value true is
mapped to text value true, and the boolean value false is mapped to text value
false.