Data type conversion table: Informix to Netezza

Table 1. Data type conversion table (Informix to Netezza)
Informix® data types Netezza® data types
CHAR(n) CHAR(n) or NCHAR(n) if UTF-8
VARCHAR(n[,m]) VARCHAR(n) or NVARCHAR if UTF-8
NCHAR(n) NCHAR(n) (UTF-8)
NVARCHAR(n[,m]) NVARCHAR(n) (UTF-8)
BOOLEAN BOOLEAN
SMALLINT SMALLINT
INT / INTEGER INTEGER
BIGINT BIGINT
INT8 BIGINT
SERIAL[(start)] N/A (see note 1)
BIGSERIAL[(start)] N/A (see note 1)
SERIAL8[(start)] N/A (see note 1)
DOUBLE PRECISION / FLOAT[(n)] DOUBLE
REAL / SMALLFLOAT REAL
NUMERIC / DEC / DECIMAL(p,s) DECIMAL(p,s)
NUMERIC / DEC / DECIMAL(p) DECIMAL(p*2,p)
NUMERIC / DEC / DECIMAL DECIMAL(32,16)
MONEY(p,s) DECIMAL(p,s)
MONEY(p) DECIMAL(p,2)
MONEY DECIMAL(16,2)
TEXT N/A
BYTE N/A
DATE DATE
DATETIME HOUR TO SECOND TIME
DATETIME YEAR TO FRACTION(p) TIMESTAMP
INTERVAL YEAR[(p)] TO MONTH CHAR(50)
INTERVAL YEAR[(p)] TO YEAR CHAR(50)
INTERVAL MONTH[(p)] TO MONTH INTERVAL
INTERVAL DAY[(p)] TO FRACTION(n) INTERVAL
INTERVAL DAY[(p)] TO SECOND INTERVAL
INTERVAL DAY[(p)] TO MINUTE INTERVAL
INTERVAL DAY[(p)] TO HOUR INTERVAL
INTERVAL DAY[(p)] TO DAY INTERVAL
INTERVAL HOUR[(p)] TO FRACTION(n) INTERVAL
INTERVAL HOUR[(p)] TO SECOND INTERVAL
INTERVAL HOUR[(p)] TO MINUTE INTERVAL
INTERVAL HOUR[(p)] TO HOUR INTERVAL
INTERVAL MINUTE[(p)] TO FRACTION(n) INTERVAL
INTERVAL MINUTE[(p)] TO SECOND INTERVAL
INTERVAL MINUTE[(p)] TO MINUTE INTERVAL
INTERVAL SECOND[(p)] TO FRACTION(n) INTERVAL
INTERVAL SECOND[(p)] TO SECOND INTERVAL
INTERVAL FRACTION[(p)] TO FRACTION(n) INTERVAL
Notes:
  1. For more details about serial emulation, see SERIAL data types.