Example

The following isql query to the pubs2 database finds information on discounts:

select * from discounts

This query produces the following result set:

discounttype          stor_id lowqty highqty discount
--------------------- ------- ------ ------- ---------
Initial Customer      NULL      NULL    NULL 10.500000
Volume Discount       NULL       100    1000 6.700000
Huge Volume Discount  NULL      1001    NULL 10.000000
Customer Discount     8042      NULL    NULL 5.000000

This result set can be represented in XML in many ways. The following is an XML representation produced by ASE Web Services and formatted in SQLX, which is part of the ANSI standard for SQL:

<?xml version="1.0" encoding="UTF-8">
<ws xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <row>
      <discounttype>Initial Customer</discounttype>
      <discount>10.5</discount>
   </row>
   <row>
      <discounttype>Volume Discount</discounttype>
      <lowqty>100</lowqty>
      <highqty>1000</highqty>
      <discount>6.7</discount>
   </row>
   <row>
      <discounttype>Huge Volume Discount
</discounttype>
      <lowqty>1001</lowqty>
      <discount>10.0</discount>
   </row>
   <row>
      <discounttype>Customer Discount</discounttype>
      <stor_id>8042</stor_id>
      <discount>5.0</discount>
   </row>
</ws>

The initial line describes the XML version and character encoding. The remaining tags are user-defined and describe both the structure and data of the document. These user-defined tags enable documents to be customized for a specific application, such as one that uses discount information to compute prices.