User Guide > Troubleshooting > Exception in SQL statement create table
Was this helpful?
Exception in SQL statement create table
 
Error Code
2
Error Message
Sending updates to DMS: Exception in create table for <User>.<TableName>: DB2 SQL Error: SQLCODE=-20441, SQLSTATE=428H2, SQLERRMC=BOOLEAN, DRIVER=<DriverVersion>. Check log for more details.
Description
This error is usually displayed for JDBC (IBM DB2) connector due to restriction on the Boolean data type.
Cause/Solution
 
Cause: There is restriction on the boolean data type. The Boolean data type cannot be used to define the data type of a column in a table or a view.
Solution: If source contains boolean data, it should be manually mapped with the correct data type:
1. Click the Mapping tab.
2. Modify the data type and size of the boolean data type field.
3. Run the transformation.
Related Information
Restrictions on the Boolean data type
 
Last modified date: 02/09/2024