What steps will reproduce the problem?
1. Create a connection to DB2 via pyodbc
2. Run a SQL select query which selects xml column
> # define conn_string and query beforehand
> connection = pyodbc.connect(conn_string)
> cursor = connection.cursor()
> cursor.execute(query)
Expected output: run query successfully
Current behavior: cursor.execute() raises exception with following error message: "ODBC data type -370 is not supported. Cannot read column XML_CONTENT"
Versions: pyodbc 3.0.7, OS: SLES 11.2, DB2 10.1, unixODBC 2.2.12
I see only SQL_SS_XML data type in pyodbc upstream code, which is SQL Server exclusive. afaik the default SQL data type is SQL_XML. Considering this, it is possible that access to XML columns will fail in Postgres as well.
While this issue is not fixed, I'll try to set DB2 to use SQL_SS_XML data type instead of SQL_XML using the information in the following URL:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=%2Fcom.ibm.db2.luw.apdv.cli.doc%2Fdoc%2Fr0023298.html