Composite Keys

Composite keys use several columns in a relational data table to form a unique index. The entries you make (via a user script) in the item_key column of the DMS_ITEMS client control table determine the order in which the columns are used in the key.

Note: If you specify a member of a DMSII GROUP as part of a composite key, you must also set the corresponding item_key column for the GROUP to a value of 1 so that the define (or redefine) command picks it up.

To avoid this step, define the composite key in the DBGenFormat parameter file on the host.