Previous Topic: Chained Set ManagementNext Topic: Chained Sets


Overview

Physically Link Record Occurrences Together

Chained sets can be used to physically link related record occurrences together. In a chained set, a pointer in each member record occurrence's prefix contains the db-key of the logically next occurrence of the set.

Defining a Chained Set

Define a set as chained as follows:

Name

Description

Non-SQL schema definition

MODE IS CHAIN on the SET statement.

SQL schema definition

LINKED CLUSTERED on the CONSTRAINT statement. When a constraint is implemented as a chained set, the referenced table is the owner of the set and the referencing table is the member.