problems displaying results in ibm_db

[ptn]

On Jul 1, 3:20 pm, digz <Digvijo... at gmail.com> 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<NEWLINE CHARACTER HERE>
1 ROWS ONLY')

You need to escape that little '\n' with a backslash:

result = ibm_db.exec_immediate( conn, 'SELECT * FROM TEST FETCH FIRST\
1 ROWS ONLY')

Better yet, use implicit string concatenation:

result = ibm_db.exec_immediate( conn, 'SELECT * FROM TEST FETCH FIRST'
'1 ROWS ONLY')

Note that now you have two strings: 'SELECT * FROM TEST FETCH FIRST'
and  '1 ROWS ONLY'


Pablo Torres N.