XMLDefaultDescribeMapping IBM data server driver configuration keyword
Controls the SQL data type that is returned when XML columns and parameter markers are described.
- Equivalent CLI keyword
- MapXMLDescribe
- Equivalent IBM® data server provider for .NET connection string keyword
- N/A
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="XMLDefaultDescribeMapping" value="-370 | -350 | -152 | -99 | -98"/>- Default setting:
- -370: The default SQL data type for XML data is SQL_XML.
- Usage notes:
- To control the SQL data type that is returned when XML columns and parameter markers are described, set XMLDefaultDescribeMapping to one of the following integer values:
- -370: Returns the default SQL_XML SQL data type
- -350: Returns the SQL_DBCLOB SQL data type
- -152: Returns the SQL_SS_XML SQL data type Remember: The SQL_SS_XML value of -152 belongs to the reserved range of Microsoft SQL Server and is not defined by IBM.
- -99: Returns the SQL_BLOB SQL data type
- -98: Returns the SQL_CLOB SQL data type
The data length for XML values mapped to LOB types is the maximum length for the mapped data type.
When used with the LobAsLongDataMode keyword set to the value 1, XML values mapped to LOB data types are mapped to the corresponding LONG data type.
Character types that are specified for the XMLDefaultDescribeMapping keyword can result in data loss during data conversion if the application code page does not support all of the characters in the source data. Mapping XML values to character types.
The XMLDefaultDescribeMapping keyword can be used to provide compatibility with applications that access XML columns as CLOB or BLOB, or use Microsoft application development technologies.