Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Schema DDL Linking record types
U929-J-Z125-9-76 79
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007
24. Oktober 2007 Stand 09:30.23 Pfad: G:\vogt\fsc\uds\Manuale\en\udsent_e\udsent.k04
4.6.2 Defining the type of membership of records in a set
MANDATORY AUTOMATIC
MEMBER IS record-name
OPTIONAL MANUAL
The records of a member record type do not automatically have to be members in a set
occurrence. The type of membership of a record in a set can be defined under two aspects:
1. At which point is the record to be inserted in the set occurrence?
AUTOMATIC
The member record is automatically inserted in the set occurrence at storage time
(see the “Application Programming” manual, STORE).
MANUAL
The member record is not automatically inserted in the set occurrence at storage
time. Membership in the set occurrence only takes effect when a specific DML
statement is entered (see the “Application Programming” manual, CONNECT).
2. What type of link is to exist between an existing member and an owner?
MANDATORY
The link is fixed. A member record can only exist in connection with an owner
record. In this case, membership in a set occurrence can only be released by
making the member record a member of another set occurrence of the same set or
by deleting it from the database (see the “Application Programming” manual,
MODIFY and ERASE).
OPTIONAL
The link can be established or released by the database programmer (see the
manual “Application Programming”, CONNECT and DISCONNECT).
A member can be released from a set occurrence without the member record being
deleted.