Removes records from the sets you specify in the TO list of the
CONNECT statement. The DISCONNECT statement can be used only for
sets in which Oracle CODASYL DBMS retention is optional.
Format
DISCONNECT context-name-1 [FROM] set-name-1 [,...]
1 – Arguments
context-name-1
Is the name of a valid context variable or the name of a
collection with a selected record. The target record must be a
member of the specified sets.
set-name
Is the name of a Oracle CODASYL DBMS set.
2 – Examples
The following example removes a part with a specified PART_ID
from its membership in the set ALL_PARTS_ACTIVE:
DTR> FOR P IN PART WITH PART_ID = "TU4722AS"
CON> DISCONNECT P FROM ALL_PARTS_ACTIVE
DTR>
The following example removes the group named PLANT ENGINEERING
from the set MANAGES:
DTR> FIND GROUPS WITH GROUP_NAME = "PLANT ENGINEERING"
DTR> SELECT
DTR> DISCONNECT CURRENT FROM MANAGES
DTR>