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
>
==
--
http://mail.python.org/mailman/listinfo/python-list
