This is a total stab in the dark - would the query be changed by Tableau if you create a calculated field which references the existing Z field, but pads it with a couple of spaces to force it to be more than 1 character? I.e;
TestField = " " + [Z]
I'd be interested to know if that forces Tableau to generate the SQL differently.
tableau v 10.0, this is the first time I'm trying to hook into this table.
No I wasn't aware long varchar was deprecated. I'll look into having it changed.
nope, that didn't work It creates the following:
(' ' || "table_A"."Z") as "calculation...."
and doesn't remove the original
thanks for the suggestion.
So I changed all my LONG VARCHAR fields to be VARCHAR(), took a bit but this solved the issue with Tableau thinking these fields were CHAR fields. And now my database is ready for when IBM drops support for LONG VARCHAR Thanks for pointing this out Dmitry.