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.