Chapter 4 Working with an XML model

Modifying the mapping of an attribute

You can modify the default mapping created for an attribute. The Attribute Mappings property sheet can be used to fine-tune the mapping between an attribute in the current element and table columns, class attributes or element attributes in the data source.

In the "Mapped to" box, you can see the column or attribute expression. By default, columns or attributes used in this expression are prefixed by their tables, classes or elements. You can customize the content of the Mapped To box by inserting comments manually. You can also click the Ellipsis button and use the SQL Editor (for PDM data source) or Object Expression Editor (for OOM or XML data source) to modify the default mapping syntax. To recover the default column expression, click the User-defined tool.

For more information about the Object Expression Editor, see the Modifying the default mapping syntax using the Object Expression Editor section in the Mapping Editor chapter, in the General Features Guide .

In the Sources tab, it is possible to select several columns or attributes and map them to the current attribute. To do so, you have to use the Add Sources tool to select columns or attributes from the list of columns or attributes belonging to the tables, classes or elements mapped to the current element. When you add columns or attributes from the Sources tab, and the column or attribute expression has not been modified by the user, the content of the Mapped To box in the General tab is updated.

Steps To modify the mapping of an attribute:

  1. In the Mapping tab, select the Attributes Mapping sub-tab to display the corresponding sub-tab.
  2. Select an attribute in the list and click the Properties tool to display the Attribute Mappings Properties dialog box.
  3. Click the Sources sub-tab and click the Add Sources tool to select source columns or attributes from a selection dialog box and click OK.

    The columns or attributes appear in the Sources list.
  4. Click the General tab to display the corresponding tab. The selected columns or attributes appear in the "Mapped to" box.
  5. Click OK.

 

Copyright (C) 2006. Sybase Inc. All rights reserved.