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>