Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Question: how do I set ibm_db.SQL_ATTR_TXN_ISOLATION with ibm_db_dbi? #931

Closed
j-bennet opened this issue May 1, 2024 · 2 comments
Closed

Comments

@j-bennet
Copy link

j-bennet commented May 1, 2024

In IBM org, I see examples like this one:

conn = dbi.connect()
conn.set_option({ dbi.SQL_ATTR_TXN_ISOLATION: dbi.SQL_TXN_NO_COMMIT })

https://github.com/IBM/ibmi-oss-examples/blob/37f17dc6527e1f28314e055c050bb426f5cfe0f1/machinelearning/dbconn/runsql.py#L24-L25

But the current ibm_db_dbi does not have SQL_TXN_NO_COMMIT or any other isolation level constants defined.

What's the right way to do that?

@Earammak
Copy link
Collaborator

@j-bennet, Support for the isolation level attributes has been added. Please verify through the latest pull request #932.

Thanks

@j-bennet
Copy link
Author

Thanks @Earammak!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants