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.
For more information about exporting XML with the OUTPUT statement, see OUTPUT statement [Interactive SQL].
The INPUT statement does not accept XML as a file format. However, you can import XML using the openxml procedure or the ADO.NET DataSet object.
For more information about importing XML, see Importing XML documents as relational data.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|