set isolation to dirty read (Informix)

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

Input

Database Connection

Accepted answers

flipperdm

@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.

All comments

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703