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:
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. |