在执行代码时,将近50%的总记录被插入。所有提到的程序突然停止
代码:conn = ibm_db.connect('DRIVER={IBM DB2 DRIVER};DATABASE=DEV;HOSTNAME=cloud.ibm.com;PORT=30000;PROTOCOL=TCPIP;UID=userid;pwd=password','','')
conni = ibm_db_dbi.Connection(conn)
subset = df[['col1', 'col2', 'col3', 'col4', 'col5',
'col6', 'col7', 'col8', 'col9']]
tuple_of_tuples = tuple([tuple(x) for x in subset.values])
load_db2_sql = "INSERT INTO edw.DETAILS VALUES(?,?,?,?,?,?,?,?,?)"
stmt = ibm_db.prepare(conn, load_db2_sql)
ibm_db.execute_many(stmt, tuple_of_tuples)
错误:Error 1064: Value parameters array 3386 is not homogeneous with
previous parameters array
SQLCODE=-302 BM][CLI Driver][DB2/LINUXX8664] SQL0302N The value of a
host variable in the EXECUTE or OPEN statement is out of range for its
corresponding use. SQLSTATE=22001