Database and Expert System Technology - Information Systems Reengineering, Integration and Normalization - page 41

either an OPTIONAL, AUTOMATIC, or a MANUAL member in these types.
If ALL is selected, then this record type must be specified as an OPTIONAL,
AUTOMATIC, or a MANUAL member in at least one set type declared in the
subschema. For example, the following commands are to assign the student with
student# = 1234 to the Computer Science Department.

MOVE “Computer Science” TO name.

OBTAIN Department USING name.

MOVE 1234 TO student#.

OBTAIN Student USING student#

CONNECT Student TO Department.

c. DISCONNECT [record-name-i] from set-name-j/all

The DISCONNECT statement removes the current member record from all
specified set types. If set types are enumerated, then the record type of the cur-
rent record must be an OPTIONAL member in each of the enumerated types. In
the case when ALL is selected, the record type must be an OPTIONAL member
in at least one set type of the subschema. For example, the following commands
disconnect a student record from the department of computer science.

MOVE “Computer Science” TO name.

OBTAIN Department USING name.

MOVE 1234 TO student#.

OBTAIN Student USING student#.

DISCONNECT Student FROM Department.

d. STORE record-name-i

The STORE statement actually writes the record created in the record area of
the user working area (UWA) to the database. For example, the following com-
mands store a student record of John Doe with student# = 1234.

MOVE “John Doe” TO Name.

MOVE 1234 TO student#.

STORE Student.