ibm_db_dbi.Connection.tables() returns empty list

[GoogleCodeExporter]

-What steps will reproduce the problem?
Sample IPython session:

In [1]: import ibm_db_dbi

In [2]: passwd = __import__('getpass').getpass()
Password: 

In [3]: conn = ibm_db_dbi.connect('db', 'user', passwd)

In [4]: conn.tables()
Out[4]: []

In [5]: import ibm_db

In [6]: conn = ibm_db.connect('db', 'user', passwd)

In [7]: stmt = ibm_db.tables(conn)

In [8]: ibm_db.fetch_tuple(stmt)
Out[8]: (None, 'DSN8810', 'DSN_STATEMENT_CACHE_AUX', 'AUXILIARY TABLE', '')

In [9]: ibm_db.fetch_tuple(stmt)
Out[9]: (None, 'SYSIBM', 'SYSJARCLASS_SOURCE', 'AUXILIARY TABLE', '')

-What is the expected output? What do you see instead?
With conn.tables() I expect to see a list of table metadata, I instead get
an empty list.

-What version of the product are you using? On what operating system?
Python 2.5, ibm_db 0.3.0, db2level returns:
DB21085I  Instance "user" uses "32" bits and DB2 code release "SQL08028" 
with level identifier "03090106".
Informational tokens are "DB2 v8.1.2.136", "s070720", "MI00189", and FixPak 
"15".
Product is installed at "/opt/IBM/db2/V8.1".

Original issue reported on code.google.com by fred.dub...@gmail.com on 30 Sep 2008 at 8:11

[GoogleCodeExporter]

Forgot to say that I'm on Ubuntu Hardy Heron 8.04.1.

Original comment by fred.dub...@gmail.com on 30 Sep 2008 at 9:07

[GoogleCodeExporter]

Hi fred,
       Sorry for delayed response, I was on vacation. 
There is a problem in tables() method of ibm_db_dbi.py file. I have made the 
correction. Please use the attached ibm_db_dbi.py file. 
Thanks for reporting the issue. This will be sorted out in the next release.

Thanks,
Abhigyan

Original comment by abhigyan...@in.ibm.com on 6 Oct 2008 at 12:05

• Changed state: Fixed

[GoogleCodeExporter]

Original comment by abhigyan...@in.ibm.com on 6 Oct 2008 at 12:37

Attachments:

• ibm_db_dbi.py

[GoogleCodeExporter]

fix included in latest release 0.4.0

Original comment by abhigyan...@in.ibm.com on 8 Oct 2008 at 6:33