Chapter 9 Working with Object-Oriented Models
You have to use the Mapping tab of an operation property sheet to define operation mappings. It contains the following sub-tabs:
The Criteria tab allows to specify join criteria between source tables or views. For example: EMPLOYEE.ID < 100
This query is automatically computed to figure out how to retrieve or update data in the database. If you modify the SQL query, it becomes user-defined and can no longer be automatically calculated, even when you update the mapping. You can tell that a statement is user-defined because the User-Defined tool is pressed in the toolbar.
You can recover the computed expression by clicking the User-Defined tool, this will remove any non calculated expression from the tab.
The syntax of the SQL query follows a predefined template. You can customize the query syntax by modifying the Query entry in the Profile category of the object language or extended model definition.
For more information on customizing templates, see section Defining templates, in chapter Generation Reference Guide in the Advanced User Documentation .
| Copyright (C) 2006. Sybase Inc. All rights reserved. |
| |