Skip to Content
0
Former Member
Jan 17, 2012 at 12:34 AM

DS generating invalid SQL in Informix

40 Views

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.