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:

Table 1. 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)