I am using the Database pane to load information from a DB2 database, but I am unable to use the table editor because the query that is being generated is not valid. How can I change the query?
When I click SHOW QUERY I see the following:
SELECT t.*, RID_BIT() as "RID_BIT()" FROM <schema>.<table> t
The error that I get is that RID_BIT() can not be found, as that is not a valid function on my system. How can I change/remove this function from the autogenerated query?