DB2 Version 9.7 for Linux, UNIX, and Windows

MapXMLDescribe CLI/ODBC configuration keyword

Controls the SQL data type returned when XML columns and parameter markers are described.

db2cli.ini keyword syntax:: MapXMLDescribe = -370 | -350 | -152 | -99 | -98
Default setting:: The default SQL data type for XML data is returned: SQL_XML (-370)
Usage notes:

To control the SQL data type that is returned when XML columns and parameter markers are described, set MapXMLDescribe to one of the following integer values:

-370 to return the default SQL_XML SQL data type
-350 to return the SQL_DBCLOB SQL data type
-152 to return the SQL_SS_XML SQL data type
Note: The SQL_SS_XML value of -152 belongs to the reserved range of Microsoft SQL Server and is not defined by IBM®.
-99 to return the SQL_BLOB SQL data type
-98 to return 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 in conjunction with the LongDataCompat keyword set to the value 1, XML values mapped to LOB data types will be mapped to the corresponding LONG data type as well.

Character types specified for MapXMLDescribe may 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, therefore, is only recommended with caution.

This keyword is recommended to provide compatibility with applications that access XML columns as CLOB or BLOB, or use Microsoft application development technologies.