DB2 graphic  QMF Version 8

Mapping object properties to column or parameter values

To manually map an object property to a column or parameter value, select a variable type and a variable on the Variable bar and then click a property name in the Object Inspector.

You can also type the column or parameter name preceded by an equals sign (=):

=column_name

The following table shows situations where you might want to map a column from an SQL query to a property value.

Table 13. Examples of mapping a column from an SQL query to a property value
Mapping task Procedure
Change the data symbol used in a 2-D layout 1. Delete the default data symbol. 2. Insert the new symbol. 3. Map the appropriate column to the Value property of the inserted data symbol.
Label each data point in a 2-D layout 1. Insert a Text object into the data template. 2. Map the column you want to be displayed in the label (for example, customer_name) to the Value property of the Text object.
Map an object property when the Layout wizard does not provide this step. 1. Open the data template of the layout. 2. Insert the object you want to be mapped to the column value. For example, insert a Text object if you want to display the column value as text. 3. Map the column to the Value property of the inserted objects.
Modify the mapping after you change the query for a data template. For example, you might want to duplicate a layout and data template but display different data. 1. Open the data template. 2. Right-click and click Change query and then select a new query in the dialog box. 3. In the revised data template, map the column you want to the Value property of the appropriate object in the data template.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004