Chapter 12: Storing XML Datagrams
Example
Caption
Filename
12-1
Credit card authorization datagram
creditcardauth.xml
12-2
Datagram with a "mixed markup" document fragment
theroux_book.xml
12-3
Moreover.com XML news feed
MoreoverNewsSample.xml
12-4
XSQL page to produce canonical ROWSET/ROW format
newsstory-canonical.xsql
12-5
Transforming Moreover news to ROWSET/ROW format
moreover-to-newsstory.xsl
12-6
BEFORE INSERT trigger assigns unique news story id
OnInsertBeforeNewsStory.sql
12-7
Transforming ROWSET/ROW to Moreover news format
newsstory-to-moreover.xsl
12-8
XSQL page displaying two most recent stories
latest-news.xsql
12-9
Transform AuthorizationRequest to ROWSET/ROW format
creditcardauth-to-rowset.xsl
12-10
Serving AuthorizationRequest datagrams
creditcardauth.xsql
12-11
Transforming ROWSET/ROW to AuthorizationRequest format
rowset-to-creditcardauth.xsl
12-12
SQL query using extended dot notation
example12-12.sql
12-13
Datagram from query using object types
flight-schedule-canonical.xml
12-14
Object view imposes rich structure over flat tables
flight_schedule_view.sql
12-15
Object view for the Book datagram
bookview2.sql
12-16
Canonical XML output for the Books view
bookcanonical.xml
12-17
INSTEAD OF Trigger handles Book datagram inserts
insteadofinsertonbooks2.sql
12-18
Transforming Book datagram for insert
book-to-rowset.xsl
12-19
Datagram representing multiple books
list-o-books.xml
12-20
Sample datagram with nested, repeating entries
deptemp.xml
12-21
Department view with nested employees collection
deptempobjview.sql
12-22
Canonical output for object view with nested collection
deptempcanonical.xml
12-23
Transforming master/detail info for insert
deptemp.xsl
12-24
Result of transforming deptemp.xml for insert
deptemp-transformed.xml
12-25
Product list datagram with nested structure
product.xml
12-26
Transforming document fragment to literal XML markup
insert-product.xsl
12-27
Results of quoting the XML markup for product features
quotedproduct.xml
12-28
Transforming document fragment text into elements
features-frag-to-elts.xsl
12-29
XSQL page to insert posted XML news stories
SimpleNewsInsert.xsql
12-30
Function to post XML document to a web server
PostXMLDocument.js
12-31
NewsStory.html page posts XML to SimpleNewsInsert.xsql
newsstory.html
12-32
Transforming request datagram to ROWSET/ROW format
request-to-newsstory.xsl
12-33
Inserting posted HTML form parameters with XSQL
newsform.html
12-34
Programmatically inserting news stories
MoreoverIntoNewsstory.java
12-35
Inserting AuthorizationRequest with XPath and SQLJ
CreditAuthorization.sqlj