Mapping Data Types
You can map IBM® InfoSphere® DataStage® data types to Informix® data types. When "Create Table" is set to Yes for input links, the target table is created by using the input link column definitions and the specific input link properties that define the properties for the target table.
There is no exact translation between an Informix data type and an InfoSphere DataStage data type such as MONEY. The following table shows the Informix data types that are generated from the corresponding InfoSphere DataStage data types:
InfoSphere DataStage Data Type | Informix Data Type |
---|---|
SQL_BIGINT | INT8 |
SQL_BINARY | BYTE (Not supported) |
SQL_BIT | BOOLEAN (Supported only with Informix Universal Server 9.n) |
SQL_CHAR | CHAR(n) |
SQL_DATE | DATE |
SQL_DECIMAL | DECIMAL(p, s) |
SQL_DOUBLE | DOUBLE PRECISION |
SQL_FLOAT | FLOAT(n) |
SQL_INTEGER | INTEGER |
SQL_LONGVARBINARY | BYTE (Not supported) |
SQL_LONGVARCHAR | TEXT |
SQL_NUMERIC | DECIMAL |
SQL_REAL | REAL |
SQL_SMALLINT | SMALLINT |
SQL_TIME | DATETIME hour to second |
SQL_TIMESTAMP | DATETIME |
SQL_TINYINT | Not supported |
SQL_VARBINARY | BYTE (Not supported) |
SQL_VARCHAR | VARCHAR(m,r) |