| SQL adaptation guide For IBM DB2 UDB 8.x, 9x / 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.
IBM® DB2® 9.x does not implement a BOOLEAN SQL type.
The DB2 database interface converts BOOLEAN type to CHAR(1) columns and stores '1' or '0' values in the column.