set isolation to dirty read (Informix)

[flipperdm]

Hi Everyone,

I can run this SQL script in an application like dBeaver but don't know how to set it up in Alteryx as an SQL query within an "Input Data" tool.  As you can see below, the workflow returns an error.  Is there a method that I can use to read a DB table that would work the same way as dirty read?

Thanks,

Mark

[DiganP]

@flipperdm I don't think that Informix is supported by Alteryx as of now. You can check this link for the supported data sources. https://help.alteryx.com/11.7/DataSources/SupportedDataSources.htm. You can use the ODBC connections to try to connect with Alteryx, but you might see some issues with it. Also, I would recommend creating your SQL query inside the SQL Editor or Visual Query Builder instead of copying/pasting from a source. Sometimes, things do get lost in translation and causes an error. 

However, you can try creating custom database connections located in .\Alteryx\bin\RuntimeData\ODBC\Customizable ODBC Driver Connections.pdf. Note, these were originally meant for partners to develop custom connectors for customers, not for customers themselves. If you were to try this, you would be completely on your own supporting it. 

You can also suggest this idea as a feature request at https://community.alteryx.com/t5/Alteryx-Product-Ideas/idb-p/product-ideas. If the idea has already been submitted by another user, please give it your vote and add your use case in the comments Our product team is very engaged here and they are constantly looking for great ideas/features to add. Hope this helps.

[flipperdm · Accepted solution]

@DiganP Thanks for responding. I have been running several workflows for Informix using the ODBC connections and it seems to work well, just this one.  I have found a solution though which I can share for anyone that runs into record lock issues.  

[zachwatts]

You can also use the pre-SQL statement.  That is used to run a statement before your query since Alteryx doesn't like to have anything before Select in the actual SQL page.