Chapter 12: Storing XML Datagrams

ExampleCaptionFilename
12-1Credit card authorization datagramcreditcardauth.xml
12-2Datagram with a "mixed markup" document fragmenttheroux_book.xml
12-3Moreover.com XML news feedMoreoverNewsSample.xml
12-4XSQL page to produce canonical ROWSET/ROW formatnewsstory-canonical.xsql
12-5Transforming Moreover news to ROWSET/ROW formatmoreover-to-newsstory.xsl
12-6BEFORE INSERT trigger assigns unique news story idOnInsertBeforeNewsStory.sql
12-7Transforming ROWSET/ROW to Moreover news formatnewsstory-to-moreover.xsl
12-8XSQL page displaying two most recent storieslatest-news.xsql
12-9Transform AuthorizationRequest to ROWSET/ROW formatcreditcardauth-to-rowset.xsl
12-10Serving AuthorizationRequest datagramscreditcardauth.xsql
12-11Transforming ROWSET/ROW to AuthorizationRequest formatrowset-to-creditcardauth.xsl
12-12SQL query using extended dot notationexample12-12.sql
12-13Datagram from query using object typesflight-schedule-canonical.xml
12-14Object view imposes rich structure over flat tablesflight_schedule_view.sql
12-15Object view for the Book datagrambookview2.sql
12-16Canonical XML output for the Books viewbookcanonical.xml
12-17INSTEAD OF Trigger handles Book datagram insertsinsteadofinsertonbooks2.sql
12-18Transforming Book datagram for insertbook-to-rowset.xsl
12-19Datagram representing multiple bookslist-o-books.xml
12-20Sample datagram with nested, repeating entriesdeptemp.xml
12-21Department view with nested employees collectiondeptempobjview.sql
12-22Canonical output for object view with nested collectiondeptempcanonical.xml
12-23Transforming master/detail info for insertdeptemp.xsl
12-24Result of transforming deptemp.xml for insertdeptemp-transformed.xml
12-25Product list datagram with nested structureproduct.xml
12-26Transforming document fragment to literal XML markupinsert-product.xsl
12-27Results of quoting the XML markup for product featuresquotedproduct.xml
12-28Transforming document fragment text into elementsfeatures-frag-to-elts.xsl
12-29XSQL page to insert posted XML news storiesSimpleNewsInsert.xsql
12-30Function to post XML document to a web serverPostXMLDocument.js
12-31NewsStory.html page posts XML to SimpleNewsInsert.xsqlnewsstory.html
12-32Transforming request datagram to ROWSET/ROW formatrequest-to-newsstory.xsl
12-33Inserting posted HTML form parameters with XSQLnewsform.html
12-34Programmatically inserting news storiesMoreoverIntoNewsstory.java
12-35Inserting AuthorizationRequest with XPath and SQLJCreditAuthorization.sqlj