Connection to DB2 in Python

Question

I'm trying to create a database connection in a python script to my DB2 database. When the connection is done I've to run some different SQL statements.

I googled the problem and has read the ibm_db API (http://code.google.com/p/ibm-db/wiki/APIs) but just can't seem to get it right.

Here is what I got so far:

import sys
import getopt
import timeit
import multiprocessing
import random
import os
import re
import ibm_db
import time
from string import maketrans

query_str = None

conn = ibm_db.pconnect("dsn=write","usrname","secret")
query_stmt   = ibm_db.prepare(conn, query_str)
ibm_db.execute(query_stmt, "SELECT COUNT(*) FROM accounts")
result = ibm_db.fetch_assoc()
print result
status = ibm_db.close(conn)

but I get an error. I really tried everything (or, not everything but pretty damn close) and I can't get it to work.

I just need to make a automatic test python script that can test different queries with different indexes and so on and for that I need to create and remove indexes a long the way.

Hope someone has a solutions or maybe knows about some example codes out there I can download and study.

Thanks

Mestika

What happens? It would be helpful if you further explain what "doesn't work" actually means. — Nick Bastin
– Nick Bastin, Commented May 18, 2010 at 16:20

SilentGhost · Accepted Answer · 2010-05-18 16:46:43Z

4

it should be:

query_str = "SELECT COUNT(*) FROM accounts"

conn = ibm_db.pconnect("dsn=write","usrname","secret")
query_stmt   = ibm_db.prepare(conn, query_str)
ibm_db.execute(query_stmt)

answered May 18, 2010 at 16:46

SilentGhost

322k67 gold badges312 silver badges294 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Emil Devantie Brockdorff Over a year ago

Thank you so very much SilentGhost, it work like a charm! You just saved my week :-)

Emil Devantie Brockdorff · Accepted Answer · 2010-05-18 16:34:54Z

0

I'm sorry, of cause you need to error message. When trying to run my script it gives me this error:

Traceback (most recent call last):
  File "test.py", line 16, in <module>
    ibm_db.execute(query_stmt, "SELECT COUNT(*) FROM accounts")
Exception: Param is not a tuple

I'm pretty sure that it is my parameter "SELECT COUNT(*) FROM accounts" that is the problem, but I have no idea how to fix it or what to put in its place.

answered May 18, 2010 at 16:34

Emil Devantie Brockdorff

4,98413 gold badges62 silver badges79 bronze badges

Collectives™ on Stack Overflow

Connection to DB2 in Python

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related