Data, Designer

Options

In this section, you specify options that control the data that is displayed in the Result Data section.

You can also specify options to transform and validate columns of XML data.

Column Name

The name of the column in the table.

Visible

Select if you want the column output shown in the result data.

Alias

The name that you want to use for the column in the result data.

Sort Type

If you want to sort on the column, select Ascending or Descending.

Filter

To filter a column of data, click the cell, and then click . In the SQL Condition window, enter the SQL expression that defines the filter that you want to apply to the column. Alternatively, you can enter the SQL expression directly in the cell.

You cannot filter the data in an XML column.

Transform

To transform a column of XML data for display in the HTML Visualizer window, click the cell, and then click . In the Transform window, specify the information to transform the column of XML data. This feature is available only if the database object or routine contains an XML data type.

Validate

To validate a column of XML data that you have imported, click the cell, and then click . In the Validate window, select the XML schema against which to validate the imported XML data. This feature is available only if the database object or routine contains an XML data type.

Clear

Clears the filter options that you specified and resets the options to their default values for the table or the view.

Max Rows

The maximum number of rows that you want to display in the Result Data section. To display all the rows of data, type the value -1. The default value for this field is the value of the Maximum Rows for Preview option on the IBM Database Tools page of the Options window.

Result Data

This section shows the data in the table or the view, or the data in the procedure or function results, based on the filters that you specified in the Filter Option section.

Some screen readers have problems reading values in the results grid. The Microsoft^® Inspect Object screen reader is slow recognizing the cell information. The screen reader JAWS^® for Windows does not read the data in the first cell of the last row in the grid.

If the result data contains XML data, you can view the data. Click a cell that contains XML data, click the down arrow, and then select one of the following commands on the drop-down menu:

XML Designer

Opens the DB2 XML Designer, in which you can review, update, and validate the XML for a column of data.

HTML Visualizer

Opens the HTML Visualizer window, in which you can view the XML data. If you have not applied a transform, the XML data is shown in source form with syntax highlighting. If you have applied a transform, the transformed XML data is shown in the window.

Clear Data

Deletes the XML data in the cell.

If the result data contains BLOB data, you can view the data. Click a cell that contains BLOB data, click the down arrow, and then click . The BLOB Visualizer window opens.

Import

Opens the Open window, where you can specify the file that contains the data that you want to add to the table.

Export

Opens the Save As window, where you can save the data that is displayed in the Result Data section to a file. Specify one of the following file types for the data:

• XML - XML result file
• CSV - comma-delimited file
• PSV - pipe-delimited file

Cancel

Reverts to the data that was displayed when you opened the designer. All changes to the original data are removed from memory without connecting to the database.