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 columns or attributes in data source tables or classes.

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 or classes. 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 to modify the default mapping syntax. To recover the default column expression, click the User-defined tool.

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 or classes mapped to the current element. When you add columns or attributes from the Sources page, and the column or attribute expression has not been modified by the user, the content of the Mapped To box in the General page 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) 2005. Sybase Inc. All rights reserved.