Mappings from SQL to XML

Db2 maps SQL to XML data according to industry standards and performs several different mappings.

To construct XML data from SQL data, the following mappings are performed:

  • SQL character sets to XML character sets
  • SQL identifiers to XML names
  • SQL data values to XML data values

Db2 maps SQL to XML data according to industry standards. For complete information, see Information technology - Database languages - SQL- Part 14: XML-Related Specifications (SQL/XML) ISO/IEC 9075-14:2003.