使用Python从DB2导出数据

import ibm_db

conn_str = "DATABASE=<database_name>;HOSTNAME=<hostname>;PORT=<port_number>;PROTOCOL=TCPIP;UID=<username>;PWD=<password>;"
conn = ibm_db.connect(conn_str, "", "")

stmt = ibm_db.exec_immediate(conn, "SELECT * FROM <table_name>")

while ibm_db.fetch_row(stmt):
    data = ibm_db.fetch_both(stmt)
    # 处理数据

with open("output.csv", "w") as file:
    while ibm_db.fetch_row(stmt):
        data = ibm_db.fetch_both(stmt)
        # 将数据写入文件
        file.write(",".join(data) + "\n")