PythonUsesibm_dbconnecttoDB2

安装好了Python和ibm_db以后，做了几个小例子测试一下

>>> import ibm_db
>>> ibm_db.__version__
&＃39;2.0.9&＃39;
>>>

=======================================================================

#!/usr/bin/python
#Example 1: Connect to a local or cataloged database
import ibm_db

cOnn= ibm_db.connect( "dsn=SAMPLE", "db2inst1", "dbpwd" )
sql = "SELECT QUOTEID,GEO FROM DB2INST1.TRN fetch first 10 rows only with ur"
stmt = ibm_db.exec_immediate(conn, sql)
dictiOnary= ibm_db.fetch_both(stmt)
while dictionary != False:
    print(dictionary["QUOTEID"])
    print(dictionary["GEO"])
    dictiOnary= ibm_db.fetch_both(stmt)

=======================================================================
#!/usr/bin/python
Example 2: Connect to an uncataloged database
import ibm_db
cOnn= ibm_db.connect("DATABASE=SAMPLE;HOSTNAME=192.168.101.133;PORT=60006;PROTOCOL=TCPIP;UID=db2inst1;PWD=dbpwd;", "", "")
sql = "SELECT QUOTEID,GEO FROM DB2INST1.TRN fetch first 10 rows only with ur"
stmt = ibm_db.exec_immediate(conn, sql)
dictiOnary= ibm_db.fetch_both(stmt)
while dictionary != False:
    print(dictionary["QUOTEID"])
    print(dictionary["GEO"])
    dictiOnary= ibm_db.fetch_both(stmt)

=========================================================================

#!/usr/bin/python
#Example 3: Connect to an uncataloged database with SSL enabled
import ibm_db
cOnn= ibm_db.connect("DATABASE=SAMPLE;HOSTNAME=192.168.101.133;PORT=50001;SECURITY=SSL;UID=db2inst1;PWD=dbpwd;SSLServerCertificate=/home/db2inst1/db2_ssl/db2_ssl_keydb.arm;", "", "")
sql = "SELECT QUOTEID,GEO FROM DB2INST1.TRN fetch first 10 rows only with ur"
stmt = ibm_db.exec_immediate(conn, sql)
dictiOnary= ibm_db.fetch_both(stmt)
while dictionary != False:
    print(dictionary["QUOTEID"])
    print(dictionary["GEO"])
    dictiOnary= ibm_db.fetch_both(stmt)