IBM DB2 BOOLEAN SQL type

The native BOOLEAN type is now used instead of CHAR(1) for DB2 11.x.

IBM DB2 LUW version 11.1.1.1 introduced the BOOLEAN SQL type.

Before Genero 3.20, the BOOLEAN type was converted to CHAR(1), storing the value '1' for TRUE and '0' for FALSE.

Starting with Genero 3.20, when connected to DB2 11.1 or +, the BOOLEAN keyword is left as is in DDL statements such as CREATE TABLE and ALTER TABLE. The fgldbsch database schema extraction tool will detect BOOLEAN columns and write the corresponding type into .sch files.