On Jul 1, 3:20 pm, digz wrote:
> result = ibm_db.exec_immediate( conn, 'SELECT * FROM TEST FETCH FIRST
> 1 ROWS ONLY')
You have the same string split into two lines, which means that what
you actually have is this:
result = ibm_db.exec_immediate( conn, 'SELECT * FROM TEST FETCH
FIRST
1 ROWS ONLY
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
