Overview

The changes in XML Services enhance three main areas:

• Extended XML query language for the xmlextract built-in function and xmltest predicate.

  • Support for XPath string functions:

    • toupper(...)

    • tolower(...)

    • normalize-space(...)

    • concat(...)

  • Support for parenthesized XPath expressions

  • XPath standards convergence:

    • Removal of nonstandard subscript expressions

    • Interpretation of the “//” operator

• Enhanced datatype support in the for xml clause of select statements:

  • text, image, binary, and varbinary

  • java.lang.String

• Enhanced datatype support for xmlextract, xmlparse, and xmlrepresentation:

  • xmlextract – can return the result XML fragment as java.lang.String.

  • xmlparse – return the parsed document as a varbinary datatype.

  • xmlrepresentation – can accept varbinary XML documents.

• Enhanced Java-XML sample code:

  • A Java-based ForXmlTree function to map SQL data to a hierarchic XML document

  • A Java-based OpenXml function to extract a SQL table from a hierarchic XML document

  • Java-based SQLX mapping functions for SQL queries that return multiple result sets

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF