David, never done that. But a quick google reveals:
http://sourceforge.net/projects/pydb2/ there is a python package, called pydb2. So the most propable code will be: import pydb2 cn=pydb2.connect(database="database", host="host", user="user", password="password") cs=cn.cursor() cs.execute("select foo from bar") for row in cs.fetchall(): print row using help (pydb2.connect) you may get some information about the fitting connect-parameters for your database. But I guess you know much more about DB2 than me and will figure that out. (i.e.: with Oracle it is just connect("user","pwd", "instanz") Best wishes, Harald On 10/23/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hello, > > I am new to Python and I am trying to work out if it is possible to use > Python to read DB2 version 8/9 tables on an AIX server. The code will > reside on the same server as the database. > > If it is possible, does anyone have any examples of connecting to a DB2 > database they could forward to me? > > Regards > > Dave Lloyd > ************************************************************************* > > This e-mail may contain confidential information or be privileged. It is > intended to be read and used only by the named recipient(s). If you are not > the intended recipient(s) please notify us immediately so that we can make > arrangements for its return: you should not disclose the contents of this > e-mail to any other person, or take any copies. Unless stated otherwise by an > authorised individual, nothing contained in this e-mail is intended to create > binding legal obligations between us and opinions expressed are those of the > individual author. > > The CIS marketing group, members of which are authorised and regulated by the > Financial Services Authority, includes: > Co-operative Insurance Society Limited Registered in England number 3615R > CIS General Insurance Limited Registered in England number 29999R > CIS Unit Managers Limited Registered in England and Wales number 2369965 > CIS Policyholder Services Limited Registered in England and Wales number > 3390839 > > Registered offices: Miller Street, Manchester M60 0AL > Internet http://www.cis.co.uk > > > CIS & the CIS logo (R) Co-operative Insurance Society Limited > > > ************************************************************************* > _______________________________________________ > DB-SIG maillist - DB-SIG@python.org > http://mail.python.org/mailman/listinfo/db-sig > -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 fx 01212-5-13695179 - EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned! _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
