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

Disable SQL_ATTR_CURRENT_SCHEMA in connect on IBM i #10

Closed
kadler opened this issue Apr 22, 2021 · 0 comments
Closed

Disable SQL_ATTR_CURRENT_SCHEMA in connect on IBM i #10

kadler opened this issue Apr 22, 2021 · 0 comments

Comments

@kadler
Copy link
Owner

kadler commented Apr 22, 2021

This line should be part of the else leg: https://github.com/kadler/python-ibmdb/blob/ibmi/IBM_DB/ibm_db/ibm_db_dbi.py#L657

We don't have this attribute on IBM i. While we could call set_current_schema, it's already set when you connect. This attribute is misleadingly named and only needed on Db2 LUW to handle some strange oddity with SQLColumns: https://www.ibm.com/docs/en/db2/11.5?topic=attributes-connection-list#r0006816__current_schema

In addition, the code should really check that connection succeeded before setting it, which is what lead to #9

@kadler kadler changed the title Disable SQL_ATTR_CURRENT_SCHEMA on IBM i Disable SQL_ATTR_CURRENT_SCHEMA in connect on IBM i Apr 22, 2021
@kadler kadler closed this as completed in 58b38a9 Apr 22, 2021
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

1 participant