Examples of publishing XML values - IBM DB2 9.7 for Linux, UNIX, and Windows

Example: Construct an XML document with constant values
This simple example shows how you can construct constant XML values suitable for publishing with SQL/XML publishing functions.

Example: Construct an XML document with values from a single table
This example shows how you can construct XML values suitable for publishing from a single table with SQL/XML publishing functions.

Example: Construct an XML document with values from multiple tables
This example shows how you can construct XML values suitable for publishing from multiple tables with SQL/XML publishing functions.

Example: Construct an XML document with values from table rows that contain null elements
This example shows how you can construct XML values suitable for publishing from table rows that contain null elements with SQL/XML publishing functions.

Example: Publishing data with XQuery
This example shows how you can construct XML values suitable for publishing not only with SQL/XML publishing functions but also with XQuery expressions.