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) if SBCS, NCHAR(n) if UTF-8
VARCHAR(n[,m]) VARCHAR(n) if SBCS, NVARCHAR(n) if UTF-8
NCHAR(n) NCHAR(n) (UTF-8)
NVARCHAR(n[,m]) NVARCHAR(n) (UTF-8)
BOOLEAN BOOLEAN
SMALLINT SMALLINT
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
DECIMAL(p,s) DECIMAL(p,s)
DECIMAL(p) DECIMAL(p*2,p)
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 MINUTE TIME
DATETIME HOUR TO SECOND TIME
DATETIME HOUR TO FRACTION(n) TIME
DATETIME YEAR TO MONTH TIMESTAMP
DATETIME YEAR TO DAY TIMESTAMP
DATETIME YEAR TO HOUR TIMESTAMP
DATETIME YEAR TO MINUTE TIMESTAMP
DATETIME YEAR TO SECOND TIMESTAMP
DATETIME YEAR TO FRACTION(n) 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 and BIGSERIAL data types.