如题,怎么使用python连接db2:
1、安装setuptools,下载地址http://pypi.python.org/pypi/setuptools
2、打开cmd窗口,输入 easy_install ibm_db
3、连接db2
>>> import ibm_db
>conn=ibm_db.connect("DATABASE=XXXXX;HOSTNAME=XX.XX.XX.XX;PORT=50021;PROTOCOL=TCPIP;UID=XXXX;PWD=XXXXX;","","")
>>> if conn:
sql="select OPERATOR_DATE,sum(stock_wt) STOCK_SUM from T_AX_BMDV_MM02 where REGION_CODE='A01' group by OPERATOR_DATE"
stmt=ibm_db.exec_immediate(conn,sql)
result=ibm_db.fetch_both(stmt)
while(result):
print "Result:",result[0]
result=ibm_db.fetch_both(stmt)
结果类似以下图片: