Home

	Expand Search

XML Services in Adaptive Server Enterprise

Appendix B The sample_docs Example Table

Titles table representation

Titles table representation

This section shows the XML representation of selected columns of the titles table.

set stringsize 16384
select text_doc from sample_docs
where name_doc='titles' 

 text_doc
----------------------------------------------------
 <titles
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <row>
     <title_id>BU1032<title_id>
     <title>The Busy Executive's Data Base
           Guide</title>
     <type>business</type>
     <pub_id>1389</pub_id>
     <price>19.99</price>
     <advance>5000.00</advance>
     <total_sales>4095</total_sales>
  </row>

  <row>
     <title_id>BU1111</title_id>
     <title>Cooking with Computers:
               Surreptitious Balance Sheets</title>
     <type>business </type>
     <pub_id>1389</pib_id>
     <price>11.95</price>
     <advance>5000.00</advance>
     <total_sales>3876</total_sales>
  </row>

  <row>
     <title_id>BU2075</title_id>
     <title>You Can Combat Computer Stress!</title>
     <type>business </type>
     <pub_id>0736</pub_id>
     <price>2.99</price>
     <advance>10125.00</advance>
     <total_sales>18722</total_sales>
  </row>

  <row>
     <title_id>BU7832</title_id>
     <title>Straight Talk About Computers</title>
     <type>business </type>
     <pub_id>1389</pub_id>
     <price>19.99</price>
     <advance>5000.00</advance>
     <total_sales>4095</total_sales>
  </row>

  <row>
     <title_id>MC2222</title_id>
     <title>Silicon Valley Gastronomic Treats</title>
     <type>mod_cook</type>
     <pub_id>0877</pub_id>
     <price>19.99</price>
     <advance>0</advance>
     <total_sales>2032</total_sales>
  </row>

  <row>
     <title_id>MC3021</title_id>
     <title>The Gourmet Microwave</title>
     <type>mod_cook</type>
     <pub_id>0877</pub_id>
     <price>2.99</price>
     <advance>15000.00</advance>
     <total_sales>22246</total_sales>
  </row>

  <row>
     <title_id>MC3026</title_id>
     <title>The Psychology of Computer Cooking</title>
     <type>UNDECIDED</type>
     <pub_id>0877</pub_id>
  </row>

  <row>
     <title_id>PC1035</title_id>
     <title>But Is IT User Friendly?</title>
     <type>popular_comp</type>
     <pub_id>1389</pub_id>
     <price>22.99</price>
     <advance>7000.00</advance>
     <total_sales>8780</total_sales>
  </row>

  <row>
     <title_id>PC8888</title_id>
     <title>Secrets of Silicon Valley</title>
     <type>popular_comp</type>
     <pub_id>1389</pub_id>
     <price>20.00</price>
     <advance>8000.00</advance>
     <total_sales>4095</total_sales>
  </row>

  <row>
     <title_id>PC9999</title_id>
     <title>Net Etiquette</title>
     <type>popular_comp</type>
     <pub_id>1389</pub_id>
  </row>

  <row>
     <title_id>PS1372</title_id>
     <title>Computer Phobic and Non-Phobic
         Individuals: Behavior Variations</title>
     <type>psychology </type>
     <pub_id>0877</pub_id>
     <price>21.59</price>
     <advance>7000.00</advance>
     <total_sales>375</total_sales>
  </row>

  <row>
     <title_id>PS2091</title_id>
     <title>Is Anger the Enemy?</title>
     <type>psychology </type>
     <pub_id>0736</pub_id>
     <price>10.95</price>
     <advance>2275.00</advance>
     <total_sales>2045</total_sales>
  </row>

  <row>
     <title_id>PS2106</title_id>
     <title>Life Without Fear</title>
     <type>psychology </type>
     <pub_id>0736</pub_id>
     <price>7.99</price>
     <advance>6000.00</advance>
     <total_sales>111</total_sales>
  </row>

  <row>
     <title_id>PS3333</title_id>
     <title>Prolonged Data Deprivation:
           Four Case Studies</title>
     <type>psychology</type>
     <pub_id>0736</pub_id>
     <price>19.99</price>
     <advance>2000.00</advance>
     <total_sales>4072</total_sales>
  </row>

  <row>
     <title_id>PS7777</title_id>
     <title>Emotional Security:
         A New Algorithm</title>
     <type>psychology </type>
     <pub_id>0736</pub_id>
     <price>7.99</price>
     <advance>4000.00</advance>
     <total_sales>3336</total_sales>
  </row>

  <row>
     <title_id>TC3218</title_id>
     <title>Onions, Leeks, and Garlic:
        Cooking Secrets of the Mediterranean</title>
     <type>trad_cook </type>
     <pub_id>0877</pub_id>
     <price>20.95</price>
     <advance>7000.00</advance>
     <total_sales>375</total_sales>
  </row>

  <row>
     <title_id>TC4203</title_id>
     <title>Fifty Years in Buckingham
          Palace Kitchens</title>
     <type>trad_cook </type>
     <pub_id>0877</pub_id>
     <price>11.95</price>
     <advance>4000.00</advance>
     <total_sales>15096</total_sales>
  </row>

  <row>
     <title_id>TC7777</title_id>
     <title>Sushi, Anyone?</title>
     <type>trad_cook </type>
     <pub_id>0877</pub_id>
     <price>14.99</price>
     <advance>8000.00</advance>
     <total_sales>4095</total_sales>
  </row>

 </titles>

(1 row affected)