DTRHELP.HLB  —  Commands Statements Clauses, DISCONNECT Statement
       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>
Close Help