使用Python连接DB2数据库分发EXCEL数据

import ibm_db
import ibm_db_dbi
import pandas as pd

# 连接字符串
connStr = "DATABASE=RGRL;HOSTNAME=192.168.1.5;PORT=50000;PROTOCOL=TCPIP;UID=DB2ADMIN;PWD=123456;"
#连接对象
conn = ibm_db.connect(connStr, "", "")
#查询语句
sql = "SELECT * FROM BJSOFT.ACCESSRIGHTSET " \
      "WHERE NAME IS NOT NULL"
#dbi连接对象
conn = ibm_db_dbi.Connection(conn)
#执行SQL
df = pd.read_sql(sql, conn)
for index,row in df.iterrows():
    print(row['NAME'])
    sql2="select * from BJSOFT.ACCESSRIGHTSET WHERE NAME='"+row['NAME']+"'"
    print(sql2)
    df2=pd.read_sql(sql2,conn)
    print(df2.size)
    if df2.shape[0]>0:
        df2.to_excel('d:/'+row['NAME']+'.xlsx')