The for xml clause of the SQL select statement maps the query’s result set to a SQLX-formatted XML document. See “for xml clause” in Chapter 4, “XML Mapping Functions,” in XML Services for syntax and usage information.
Adaptive Server 12.5.2 extends the datatypes that can be specified in a select...for xml statement to include:
binary and varbinary
image
text
java.lang.String
binary, varbinary, and image data are represented in the generated XML document as either hex or base64 values. You can specify the value type by using the option “binary = { hex | base64 }” as described in “SQLX option definitions” in Chapter 4 of XML Services.
Copyright © 2004. Sybase Inc. All rights reserved. |
![]() |