For Db2 V9.1 and higher for Linux/UNIX/Windows, the Db2 driver supports the XML data type. Which JDBC data type the XML data type is mapped to depends on whether the JDBCBehavior and XMLDescribeType properties are set:

  • If XMLDescribeType=clob or XMLDescribeType=blob, the driver maps the XML data type to the JDBC CLOB or BLOB data type, respectively, regardless of the setting of the JDBCBehavior property.
  • If JDBCBehavior=1 (default) and the XMLDescribeType property is not set, the driver maps XML data to the JDBC CLOB data type.
  • If JDBCBehavior=0 and the XMLDescribeType property is not set, XML data is mapped to SQLXML.