| SQL adaptation guide For IBM Netezza 1.x / Data dictionary | |
Informix® supports the BOOLEAN data type, which can store 't' or 'f' values; Genero BDL implements the BOOLEAN data type in a different way. As in other programming languages, Genero BOOLEAN stores integer values 1 or 0 (for TRUE or FALSE). The type was designed this way to assign the result of a boolean expression to a BOOLEAN variable.
Netezza® supports the BOOLEAN data type and stores 't' or 'f' values for TRUE and FALSE representation. It is not possible to insert the integer values 1 or 0: Values must be true, false, 't', 'f', '1' or '0'.
The Netezza database interface supports the BOOLEAN data type, and converts the BDL BOOLEAN integer values to a CHAR(1) of '1' or '0'.