BOOLEAN data type

Informix®

Informix supports the BOOLEAN data type, which can store 't' or 'f' values.

Genero BDL implements the BOOLEAN data type in a different way: A BOOLEAN variable stores integer values 1 or 0 (for TRUE or FALSE). This type is designed to hold the result of a boolean expression.

Netezza®

Netezza supports the BOOLEAN data type and stores 't' or 'f' values for TRUE and FALSE representation.

Note: It is not possible to insert the integer values 1 or 0 into Netezza BOOLEAN columns: Values must be true, false, 't', 'f', '1' or '0'.

Solution

The Netezza database interface converts the BOOLEAN integer values to a CHAR(1) values '1' or '0'.

The BOOLEAN type translation can be controlled with the following FGLPROFILE entry:
dbi.database.dsname.ifxemul.datatype.boolean = { true | false }
For more details see IBM Informix emulation parameters in FGLPROFILE.