DB2 XML Designer

Source

Shows the fully qualified name of the column of XML data.

Text View

This page shows the XML source for a column of XML data. You can review the XML elements and text, and update the content of the XML column directly in the source by changing, deleting, and adding elements and text. The XML editor on this page features syntax highlighting and IntelliSense.

Grid View

This page shows the contents of the XML column as a hierarchical grid. You can click an element to see its children or its text and attribute values. You can update the content in the grid by changing, deleting, and adding text. To return to the parent element, click .

Sample XML

This page shows sample XML for a selected schema. To generate the sample XML, expand the Advanced Options section, select an XML schema, and then click Generate Sample. To use the sample XML as a template for adding new content to the XML data, select and copy the lines that you want to use, and then paste the copied lines in the appropriate location on the Text View page.

Advanced Options

In this section, you select an XML schema and use it to validate the XML that you enter on the Text View page, or to generate sample XML that you can include on the Text View page.

Owner

The name of the database schema in which the corresponding XML schema is stored. You can filter the rows that are shown in the Advanced Options section to a specific database schema or set of similarly named database schemas. In the yellow cell, enter the string of characters that represent the first part of the database schema name or names.

XML schema name

The list of the XML schemas that are registered in the XML Schema Repository. You can filter the rows that are shown in the grid to a specific XML schema or set of similarly named XML schemas. In the yellow cell, enter the string of characters that represent the first part of the XML schema name or names.

Reference

To use the elements in an XML schema in the List Members option in IntelliSense, select the XML schema's Reference check box. As you enter XML on the Text View page, IntelliSense shows you the appropriate element to use.

Namespaces

To see the namespaces that are specified in an XML schema, click its corresponding Namespaces cell, and then click . The namespaces are shown in a read-only Namespaces window.

Validate

To validate the XML that you have entered on the Text View page against one or more XML schemas, select the schema or schemas in the grid, and then click this button.

Generate Sample

To generate sample XML that is based on one of the XML schemas in the grid, select the schema, and then click this button. The sample XML is shown on the Sample XML page. You can copy the XML that you want to use and paste it on the Text View page.

Open File

Replaces the data that is currently shown on the Text View page with the data in the XML file that you select in the Open window.