Re: Connecting python to DB2 database

2021-09-04 Thread Chris Angelico
On Sun, Sep 5, 2021 at 1:26 PM DFS wrote: > > On 9/3/2021 9:50 AM, Chris Angelico wrote: > > On Fri, Sep 3, 2021 at 11:37 PM DFS wrote: > >> > >> On 9/3/2021 1:47 AM, Chris Angelico wrote: > >>> On Fri, Sep 3, 2021 at 3:42 PM DFS wrote: > > Having a problem with the DB2 connector > >>>

Re: Connecting python to DB2 database

2021-09-04 Thread DFS
On 9/3/2021 9:50 AM, Chris Angelico wrote: On Fri, Sep 3, 2021 at 11:37 PM DFS wrote: On 9/3/2021 1:47 AM, Chris Angelico wrote: On Fri, Sep 3, 2021 at 3:42 PM DFS wrote: Having a problem with the DB2 connector test.py impor

Re: Connecting python to DB2 database

2021-09-03 Thread Dennis Lee Bieber
On Fri, 3 Sep 2021 09:29:20 -0400, DFS declaimed the following: > >Now can you get DB2 to accept ; as a SQL statement terminator like the >rest of the world? They call it "An unexpected token"... I've never seen a semi-colon used for SQL statements via a db-api adapter. The semi-colon

Re: Connecting python to DB2 database

2021-09-03 Thread Chris Angelico
On Fri, Sep 3, 2021 at 11:37 PM DFS wrote: > > On 9/3/2021 1:47 AM, Chris Angelico wrote: > > On Fri, Sep 3, 2021 at 3:42 PM DFS wrote: > >> > >> Having a problem with the DB2 connector > >> > >> test.py > >> > >> import ibm_db_dbi

Re: Connecting python to DB2 database

2021-09-03 Thread DFS
On 9/3/2021 1:47 AM, Chris Angelico wrote: On Fri, Sep 3, 2021 at 3:42 PM DFS wrote: Having a problem with the DB2 connector test.py import ibm_db_dbi connectstring = 'DATABASE=xxx;HOSTNAME=localhost;PORT=5;PROTOCOL=TCPIP;UI

Re: Connecting python to DB2 database

2021-09-02 Thread Chris Angelico
On Fri, Sep 3, 2021 at 3:42 PM DFS wrote: > > Having a problem with the DB2 connector > > test.py > > import ibm_db_dbi > connectstring = > 'DATABASE=xxx;HOSTNAME=localhost;PORT=5;PROTOCOL=TCPIP;UID=xxx;PWD=xxx;' > conn = ibm_db_

Connecting python to DB2 database

2021-09-02 Thread DFS
Having a problem with the DB2 connector test.py import ibm_db_dbi connectstring = 'DATABASE=xxx;HOSTNAME=localhost;PORT=5;PROTOCOL=TCPIP;UID=xxx;PWD=xxx;' conn = ibm_db_dbi.connect(connectstring,'','') curr = conn.cursor pri