DataStage type to Java type mapping with the Operational Decision Manager (ODM) stage
The wizard maps DataStage® column type definitions in the link to the Java™ types used for the private member variables, method return values, and method arguments when it generates Java code.
At run time, the connector maps, as necessary, the DataStage column type definitions present on the
input links to the Java types, to initialize values for the IN
and IN_OUT parameters that are associated with those links. The following table describes how the
DataStage type definition is mapped to Java type:
Some of the DataStage type
definitions can be mapped to more than one Java type. In such
scenarios, the value that is specified for the Nullable attribute determines
which of the two Java types is mapped. If the
Nullable value is set to No, the primitive Java type is selected. If the Nullable
value is set to Yes or Unknown, the object wrapper
type is selected. For example, if a link column of DataStage TinyInt type with
Signed attribute set to Yes maps to the Java primitive type
| DataStage SQL Type | Length | Scale | Extended | Java Type |
|---|---|---|---|---|
| TinyInt | (n/a) | (n/a) | Empty | byte, java.lang.Byte |
| TinyInt | (n/a) | (n/a) | Unsigned | short, java.lang.Short |
| SmallInt | (n/a) | (n/a) | Empty | short, java.lang.Short |
| SmallInt | (n/a) | (n/a) | Unsigned | int, java.lang.Integer |
| Integer | (n/a) | (n/a) | Empty | int, java.lang.Integer |
| Integer | (n/a) | (n/a) | Unsigned | long, java.lang.Long |
| BigInt | (n/a) | (n/a) | Empty | long, java.lang.Long |
| BigInt | (n/a) | (n/a) | Unsigned | java.math.BigInteger |
| Bit | (n/a) | (n/a) | (n/a) | Boolean, java.lang.Boolean |
| Float | (n/a) | (n/a) | (n/a) | float, java.lang.Float |
| Double | (n/a) | (n/a) | (n/a) | double, java.lang.Double |
| Decimal | Any | Any | (n/a) | java.math.BigDecimal |
| Char, NChar | 1 | (n/a) | Any | char, java.lang.Character |
| Char, NChar | n > 1 | (n/a) | Any | char[] |
| Char, NChar | Empty | (n/a) | Any | char[] |
| VarChar, NVarChar, LongVarChar, LongNVarChar | Any | (n/a) | Any | java.lang.String |
| Binary | 1 | (n/a) | (n/a) | byte, java.lang.Byte |
| Binary | n > 1 | (n/a) | (n/a) | byte[] |
| Binary | Empty | (n/a) | (n/a) | byte[] |
| VarBinary | Any | (n/a) | (n/a) | byte[] |
| Time | (n/a) | (n/a) | Empty | java.sql.Time |
| Time | (n/a) | (n/a) | Microseconds | java.sql.Timestamp |
| Date | (n/a) | (n/a) | (n/a) | java.sql.Date |
| Timestamp | (n/a) | (n/a) | Empty | java.util.Date |
| Timestamp | (n/a) | (n/a) | Microseconds | java.sql.Timestamp |
byte, if the
Nullable attribute is set to No and maps to Java wrapper type java.lang.Byte if its
Nullable attribute is set to Yes.DataStage character-based data types Char, NChar,
VarChar, LongVarChar, NVarChar, and LongNVarChar can also be mapped to boolean and
java.lang.Boolean
Java types. The text value "true" (not case-sensitive) maps to
boolean value true. The remaining text values map to boolean value
false.