Setting Advanced IDO Attributes

The advanced attributes of an IDO include its primary key properties, and other options.

Primary Keys reflect the primary key properties of the IDO's base table in the application or external database. The system automatically detects primary key properties except for IDOs based on an SQL view. The order of the IDO's primary key properties should match the order used in the application underlying database table. This order determines the default sort order for the IDO, which may be overridden in the application or elsewhere.

To add or edit primary keys for an IDO:

  1. On the IDOs form, select the IDO.
  2. Click Check Out.
  3. Click Advanced Attributes.
  4. In the Advanced IDO Attributes form, the Primary Keys list indicates the primary keys detected by the system and their sort order. The IDO Properties list shows the properties of the IDO. Use these steps to work with primary keys:
    • To add a property as a primary key, select the property in the IDO Properties list. Then click Add.
    • To set the sort order for the primary keys, select a primary key in the Primary Keys list. Then click Up or Down.
    • To remove a primary key, select the primary key in the Primary Keys list. Then click Remove.
  5. Click OK to save your changes.
Other advanced attributes control the behavior of IDO operation.
Attribute Description or valid values
Quote Table Aliases This flag controls whether appropriate quoting is applied to table aliases during SQL generation for the tables in this IDO. Set this flag to protect any table alias that represents an SQL keyword or reserved word in the query language of the server hosting the table’s database. If you select all table aliases to avoid duplicating SQL keywords, this flag can be cleared.