Connecting python to DB2 database

[Chris Angelico]

On Fri, Sep 3, 2021 at 3:42 PM DFS <nospam at dfs.com> wrote:
>
> Having a problem with the DB2 connector
>
> test.py
> ----------------------------------------------------------------
> import ibm_db_dbi
> connectstring =
> 'DATABASE=xxx;HOSTNAME=localhost;PORT=50000;PROTOCOL=TCPIP;UID=xxx;PWD=xxx;'
> conn = ibm_db_dbi.connect(connectstring,'','')
>
> curr  = conn.cursor
> print(curr)

According to PEP 249, what you want is conn.cursor() not conn.cursor.

I'm a bit surprised as to the repr of that function though, which
seems to be this line from your output:

<ibm_db_dbi.Connection object at 0x000002154D2FED30>

I'd have expected it to say something like "method cursor of
Connection object", which would have been an immediate clue as to what
needs to be done. Not sure why the repr is so confusing, and that
might be something to report upstream.

ChrisA