I’m kicking the tires on the Toad for Data Analysis. Trying out the Query Builder to search on one table, with a view that works in several other programs and a small set of fields from the view. The only limit is on one field I put in a where clause that I know works.
I’m connected to an Informix database through the ODBC connection. When I run the query that I built in the builder, I get this error:
ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Owner name is too long.
Toad was able to connect and load the view and list of columns. Not sure why a query it built is not able to execute.
Anybody have a suggestion?