Troubleshooting > Troubleshooting DataConnect > Execution of SQL statement create table failed
Was this helpful?
Execution of SQL statement create table failed
 
Error Code
7
Error Message
Error preparing map for execution: Error 25507 opening target 'IBM DB2 10': Exec SQL failed: SQL Statement <CREATE TABLE query>.
Description
This error is usually displayed for IBM DB2 10 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
Last modified date: 10/22/2024