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. However, you can import XML using the OPENXML operator or the ADO.NET DataSet object.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|