ASA SQL User's Guide
  Using XML in the Database
    Exporting relational data as XML

Exporting relational data as XML from Interactive SQL

The Interactive SQL OUTPUT statement supports an XML format that outputs query results to a generated XML file.

This generated XML file is encoded in UTF-8 and contains an embedded DTD. In the XML file, binary values are encoded in character data (CDATA) blocks with the binary data rendered as 2-hex-digit strings.

The INPUT statement does not accept XML as a file format.

For more information about exporting XML with the OUTPUT statement, see OUTPUT statement [Interactive SQL].