Web Result Columns (PDM)

Result columns are part of the SQL statement defined in the Implementation tab of a web operation property sheet, and are listed on its Result Columns tab. They belong to a table in the target database.

Creating a Web Result Column

You can create a Web result column in the following ways:

Open the Result Columns tab in the property sheet of a Web operation, and click the Add a Row tool. Alternatively, use the Add Result Columns from Executing SQL Statement tool to display the result columns resulting from the execution of the SQL statement in the database.
Right-click a web operation in the Browser, and select New > Result Column.

Web Result Column Properties

To view or edit a result column's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator. The General tab contains the following properties:

Property	Description
Name/Code/Comment	Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.
Data Type	[IBM DB2] Select an XML schema data type from the list, or click the Select Object tool to select a global element in an XML model open in the workspace.
Is element	[IBM DB2] Checked and greyed when a global element is attached to a result column.
Keywords	Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.