![]() ![]() XMLFOREST function This function generates a forest of XML elements. XMLELEMENT function This function generates an XML element for which you can optionally specify element content, attributes, and attribute content. XMLCONCAT function This function generates a forest of XML elements by concatenating together the XML values that are passed in to it. XMLAGG function This aggregate function generates a forest of XML elements from a collection of XML elements. As part of its SQL/XML support,Īdaptive Server Anywhere includes an XML data type that can be used to store XML documents in the database.Īdaptive Server Anywhere also supports the following SQL/XML functions that provide an alternative method to the FOR XML clauseįor generating XML documents from your relational data: SQL/XML support SQL/XML is a draft standard that describes the ways SQL can be used in conjunction with XML. Openxml procedure See openxml system procedure. ![]() See Obtaining query results as XML and SELECT statement.įor_xml_null_treatment option You can use the for_xml_null_treatment option to control how NULL values are returned by a query that includes the FOR XML Each mode allows you a different level of control over the format of the XML that is generated. FOR XML clause The SELECT statement supports a FOR XML clause with three modes, RAW, AUTO, and EXPLICIT, that allow you to obtain query resultsĪs an XML document. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |