Changes to xmlrepresentation  Examples

Chapter 2: XML Services

Extended datatype support in for xml mappings

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, 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. Examples

View this book as PDF