All pastes #190740 Raw Edit

Untitled

public text v1 · immutable
·published 2006-10-04 08:38 UTC
rendered paste body
Python 2.4.3 (#1, Sep 13 2006, 21:54:25)
[GCC 4.1.1 (Gentoo 4.1.1)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import DB2
>>> conn = DB2.Connection('DOCTEST')
>>> cur = conn.cursor()
>>> cur.execute("""SELECT TABSCHEMA, TABNAME
... FROM SYSCAT.TABLES
... ORDER BY TABSCHEMA, TABNAME
... WITH UR""")
>>> result = cur.fetchall()
>>> result

... Large amounts of crap ...

>>> del cur
>>> del conn
>>>