The IBM_INFORMIX_SA adapter provides the Python/SQLAlchemy interface to IBM INFORMIX Data Servers.

0.0.1 (2016/10/03)

1. Python 2.5.x or Jython 2.5.x .
2. SQLAlchemy o.7.3 or above.
3. IBM_DB driver and IBM_DB_DBI wrapper 1.0.1 or higher

The IBM_INFORMIX_SA Python Egg component (.egg) can be installed using the standard setuptools provided by the Python Easy Install through Python Entreprise Application Kit community portal:

http://peak.telecommunity.com/DevCenter/EasyInstall

Please follow the steps provided to Install "Easy Install" in the link above and follow up with these additional steps to install IBM_INFORMIX_SA:

1. To install IBM_INFORMIX_SA egg component available in the remote repositories (pypi.python.org):

Windows:

> easy_install ibm_informix_sa

Linux/Unix:

$ sudo easy_install ibm_informix_sa

1. To install IBM_INFORMIX_SA egg component from the downloaded .egg file

Windows:

> easy_install ibm_informix_sa-x.x.x-pyx.x.egg

Linux/Unix:

$ sudo easy_install ibm_informix_sa-x.x.x-pyx.x.egg

1. To install IBM_INFORMIX_SA from source

Standard Python setup should be used::

python setup.py install

A TCP/IP connection can be specified as the following:

from sqlalchemy import create_engine

e = create_engine("db2+ibm_db://user:pass@host[:port]/database")

For a local socket connection, exclude the "host" and "port" portions:

from sqlalchemy import create_engine

e = create_engine("db2+ibm_db://user:pass@/database")

• IBM DB2 Universal Database for Linux/Unix/Windows versions 9.7 onwards

1. Non-standard SQL queries are not supported. e.g. "SELECT ? FROM TAB1"
2. For updations involving primary/foreign key references, the entries should be made in correct order. Integrity check is always on and thus the primary keys referenced by the foreign keys in the referencing tables should always exist in the parent table.
3. Unique key which contains nullable column not supported
4. UPDATE CASCADE for foreign keys not supported
5. DEFERRABLE INITIALLY deferred not supported
6. Subquery in ON clause of LEFT OUTER JOIN not supported
7. PyODBC and Jython/zxjdbc support is experimental
8. Ge Isolation is not working and not implemented in this version for informix db

ibm_db_sa for SQLAlchemy was first produced by IBM Inc., targeting version 0.4. The library was ported for version 0.6 and 0.7 by Jaimy Azle. Port for version 0.8 and modernization of test suite by Mike Bayer. ibm_informix_sa is a library used to connect to informix db using almost all of the code used for ibm_db_sa ibm_db_sa to ibm_informix_sa Port for version 0.0.1 by Pablo Hernandez