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 |