I have a problem with one of my source tables. The table is names resource, and I'm guessing that is an informix reserved word.
The table is in informix and I can import it, add it to a dataflow and preview it without issue. The problem only occurs when I run thge job. DS sends SQL to informix like this:
Select col1, col2 from informix.resource resource
This throws an error. So I tried reproducing this in a query tool. What I found it this indeed generates a syntax error.
If I vary the command to either:
Select col1, col2 from informix.resource AS resource
or
Select col1, col2 from informix.resource resource2
It works fine. How to I change the way DS sends its SQL ?
I found an old post where someone had the same issue, but that is 3 years old.
http://www.forumtopics.com/busobj/viewtopic.php?t=137855&sid=ef00cdaab7a9ec33f4a739e15fdf7393
It there any option other than doing what they did create views to work around this ?
Thanks.