skip to main content
DataDirect Connect Drivers : DB2 Driver : Returning and Inserting/Updating XML Data
  
Returning and Inserting/Updating XML Data
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 or CLOB, depending on which JVM your application is using. The driver maps the XML data type to the JDBC SQLXML data type if your application is using Java SE 6. If your application is using an earlier JVM, the driver maps the XML data type to the JDBC CLOB data type.
* Returning XML Data
* Inserting/Updating XML Data