To use XML documents for data interchange in Adaptive Server, you must be able to store XML documents or the data that they contain in the database. To determine how best to accomplish this, consider the following:
Mapping and storage: What sort of correspondence between XML documents and SQL data is most suitable for your system?
Client or server considerations: Should the mapping take place on the client or the server?
Accessing XML in SQL: How do you want to access the elements of an XML document in SQL?
The rest of this section discusses each of these considerations; the remainder of the chapter discusses the classes and methods you can use with XML, including:
A simple example to illustrate the basics of data storage and exchange of XML documents
A generalized example that you can customize for your own XML documents