# Babelfish supports XML datatype methods
<a name="babelfish-xml-datatype-methods"></a>

Starting with version 5.4.0, Babelfish now supports stored procedures sp\$1xml\$1preparedocument and sp\$1xml\$1removedocument, rowset function OPENXML() and xml dataype method .VALUE(). With these functions and procedures querying on XML data becomes much easier.

## Understanding XML procedures and methods
<a name="babelfish-xml-datatype-methods-overview"></a>
+ **sp\$1xml\$1preparedocument** – The procedure sp\$1xml\$1preparedocument parses an XML text given as input and returns a handle to this document. This handle is valid during the session or until it is removed by sp\$1xml\$1removedocument.
+ **sp\$1xml\$1removedocument** – The procedure sp\$1xml\$1removedocument invalidates the handle which was created by procedure sp\$1xml\$1preparedocument.
+ **OPENXML()** – OPENXML provides a rowset view over an XML document. Since OPENXML is a rowset provider and it returns a set of rows, we can use OPENXML in the FROM clause just as we can use any other table, view, or table-valued function.
+ **VALUE()** – XML Datatype method VALUE() is used to extract a value from an XML instance stored in an xml type column, parameter, or variable.

## Limitations in Babelfish XML procedures and methods
<a name="babelfish-xml-datatype-methods-limitations"></a>
+ Babelfish only supports XPATH 1.0 syntax for second argument (i.e. ROWPATTERN) of OPENXML().
+ The meta-properties and flag 8 are not currently not supported in OPENXML().
+ Babelfish only supports XPATH 1.0 syntax for first argument (i.e. XQuery) of VALUE() datatype method.