Database schema compatibility

Version 2.20.06 database schema extraction now generates a different type code for BOOLEAN, that introduces a compatibility issue with older versions of fglcomp and fglform.

Note: This behavior change is related to the bug fix FGL-2048.

If database tables use data types that are equivalent to the BOOLEAN Informix® type, such as the BIT type in SQL Server, you must regenerate the .sch database schema file with the fgldbsch tool. If you keep using the schema generated by an older version such as 2.20.04, fglcomp or fglform will raise the error -6634.

This problem will only occur if your database tables use the BOOLEAN (or native equivalent type). See ODI Adaptation Guides for more details about database specific boolean types.