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.

Table 1. Netezza data types and their equivalent 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.