problems displaying results in ibm_db

digz Digvijoy.C at gmail.com
Wed Jul 1 16:20:03 EDT 2009


This simple db connectivity and select test program works in the
interactive mode

>>> import ibm_db
>>> conn = ibm_db.connect( 'DATABASE', 'user', 'passwd')
>>> result = ibm_db.exec_immediate( conn, 'SELECT * FROM TEST FETCH FIRST 1 ROWS ONLY')
>>> row = ibm_db.fetch_tuple( result )
>>> for r in row:
...    print r
...
13
ABC
4
2009-05-11

The same executed from a script using python testdb.py does not yield
anything , What am I doing wrong ?

import ibm_db
conn = ibm_db.connect( 'DATABASE', 'user', 'pwd')
result = ibm_db.exec_immediate( conn, 'SELECT * FROM TEST FETCH FIRST
1 ROWS ONLY')
row = ibm_db.fetch_tuple( result )
for r in row:
      print r

==
>python testdb.py
database value after unicode conversion is : N
database value sent to CLI is : N
>
==



More information about the Python-list mailing list