Python3使用ibm-db 连接DB2 执行sql 时报错 SQLCODE=-332 ？

Question

Python3使用ibm-db 连接DB2 执行sql 时报错 SQLCODE=-332 codepage转换错误，现在不能修改DB2 server的设置，请问怎么解决？
代码如下：

import ibm_db


conn=ibm_db.connect("DATABASE=db;HOSTNAME=host;PORT=60000;PROTOCOL=TCPIP;UID=user;PWD=pwd",'','')
sql = "SELECT * FROM T_PATENTINFO"
stmt = ibm_db.exec_immediate(conn, sql)
result = ibm_db.fetch_tuple(stmt)
print(result)

错误信息：

Traceback (most recent call last):
  File "C:\Users\xux\AppData\Local\Programs\Python\Python37\lib\site-packages\ibm_db_dbi.py", line 1434, in _fetch_helper
    row = ibm_db.fetch_tuple(self.stmt_handler)
 SQLCODE=-332

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:/PythonRepo/patent/db_fixture/ibm_db_connect.py", line 53, in <module>
    rresult = DB().search_patent()
  File "C:/PythonRepo/patent/db_fixture/ibm_db_connect.py", line 44, in search_patent
    result = self.cursor.fetchone()
  File "C:\Users\xux\AppData\Local\Programs\Python\Python37\lib\site-packages\ibm_db_dbi.py", line 1460, in fetchone
    row_list = self._fetch_helper(1)
  File "C:\Users\xux\AppData\Local\Programs\Python\Python37\lib\site-packages\ibm_db_dbi.py", line 1441, in _fetch_helper
    raise self.messages[len(self.messages) - 1]
 SQLCODE=-332

Answer 1

不知道你这个问题是否已经解决, 如果还没有解决的话:

• 建议你看下这篇博客👉 ：Python3使用ibm-db连接DB2时，报错 SQLCODE=-1042？

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 以帮助更多的人 ^-^