search

wmjie / ibm-db

Automatically exported from code.google.com/p/ibm-db
0 stars 0 forks source link

OS390 (z/OS) support #131

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I implemented a project using SQLAlchemy because I've read that there is DB2 
support available for it.

However after I've implemented a lot of code testing it successfully on SQLite 
and MySQL (while waiting for credentials for corporate DB2). When I've finally 
connected to DB2 I've figured out that it is not supported by ibm_db_sa code.

Luckily the ibm_db driver (the binary part) seemed to work, but the system 
tables had different layout. I needed also some SQL fix to support dedicated 
DB2 syntax extension of creation of the tables in the specific internal entity 
called DATABASE (sic!).

I've found the AS400Reflector that seemed more similar to the one I needed, but 
firstly it was not working for me after all (different system tables) and 
secondly - it was not integrated with the rest of the ibm_db_sa system, so it 
couldn't be used without some sort of patching the ibm_db_sa code anyway. (see 
the issue no 127 created for this - 
https://code.google.com/p/ibm-db/issues/detail?id=127 )
But it could be used as very good starting point.

There are few changes I've done into the original code to make it running in my 
project. Although it seems to work, I'm not sure if all of them are implemented 
in correct way and at least one for sure is ugly (CREATE TABLE IN DATABASE is 
partly an ugly hack). :)

I wanted IBM support team to validate this code and if any good thing can be 
extracted of it - to include OS390 (z/OS) support in the global ibm_db_sa 
official distribution. To be able to do so I needed an open issue, and so I've 
created this one.

This applies to:
ibm_db_sa-0.3.0-py2.7.egg - that needed the update
and
ibm_db-2.0.2-py2.7-win32.egg - that was working fine

Original issue reported on code.google.com by Adam.J.M...@gmail.com on 2 Aug 2013 at 3:51

GoogleCodeExporter commented 9 years ago 
Hi Adam,
 Thanks for writing Reflector for z/OS, we are happy to review your code but before this you need to sign contribution agreement which is available at http://code.google.com/p/ibm-db/wiki/Contributions .

Please sign the contribution agreement and mail us the scan copy of signed 
agreement after this only we are able to see and review your changes.

Thanks,
Rahul

Original comment by rahul.pr...@in.ibm.com on 5 Aug 2013 at 12:16