|
|
|
# First thing, last?
|
|
|
|
|
|
|
|
So far we have been running opensource on IBM i, now we'll join it to something decidedly _not_ opensource, namely DB2 for i.
|
|
|
|
|
|
|
|
Now that we finally have ODBC access for "free", we can use all manner of programming languages to talk to the database we know and love.
|
|
|
|
|
|
|
|
For Python to do that, we'll need a few things.
|
|
|
|
|
|
|
|
unixODBC (`yum install unixODBC`), or use ACS.
|
|
|
|
|
|
|
|
If you plan on doing local development, and I highly recommend that you do!
|
|
|
|
You'll need to install the ODBC driver IBM ships for your operating system.
|
|
|
|
_Currently, Win, Mac, Linux and IBM i naturally_
|
|
|
|
|
|
|
|
You can download that, from the same place you downloaded ACS, [currently that is here](https://www.ibm.com/support/pages/ibm-i-access-client-solutions), but as you know, it changes...
|
|
|
|
|
|
|
|
Finally, we'll need [PyODBC](https://pypi.org/project/pyodbc/) and [IBM_Db](https://pypi.org/project/ibm-db/) `pip install pyodbc, python39-ibm_db` handles that.
|
|
|
|
|
|
|
|
For an in-depth guide, [review the documentation](https://ibmi-oss-docs.readthedocs.io/en/latest/odbc/installation.html)
|
|
|
|
|
|
|
|
Most of this, is configured on your chroot environment, so we'll just `pip install pyodbc`... |
|
|
\ No newline at end of file |
