Data type conversions from Netezza to DataStage
When reading data, the Netezza Connector stage converts Netezza data types to InfoSphere® DataStage® data types.
Likewise, after metadata is imported through the Netezza connector, the Netezza data types are converted toIBM® InfoSphere DataStage data types. The following table shows the mapping rules between Netezza data types and InfoSphere DataStage data types.
| Netezza data types | InfoSphere DataStage data types (SQL types) |
|---|---|
| BYTEINT | TinyInt |
| SMALLINT | SmallInt |
| INT | Integer |
| BIGINT | BigInt |
| NUMERIC(p, s) | Numeric |
| FLOAT(p) | Float |
| REAL | Real |
| DOUBLE PRECISION | Double |
| CHAR(n) | Char |
| VARCHAR(n) | VarChar |
| NCHAR(n) | NChar |
| NVARCHAR(n) | NVarChar |
| BOOLEAN | Bit |
| DATE | Date |
| TIME | Time |
| TIME WITH TIME ZONE Note: The value of time with
time zone will be returned without the time zone information.
|
VarChar |
| TIMESTAMP | TimeStamp |
| INTERVAL Note: You cannot load the interval data
type from an external table.
|
VarChar |
| ROWID | BigInt |
| TRANSACTION ID | BigInt |
| DATASLICE | Integer |
The XML data type can be imported as a LOB by selecting the XML column as LOB option during metadata import. XML columns can be represented as any of the string, ustring, or LOB data types.