DTRHELP.HLB  —  Commands Statements Clauses, FINISH Command
       Ends your access to domains, domain tables, relations, and
       Oracle CODASYL DBMS records. The FINISH command also releases
       any collections associated with the domains.

       For Oracle CODASYL DBMS, when the last Oracle CODASYL DBMS domain
       or record is finished, collections are purged, a commit with
       no retention is performed, and databases are unbound. The last
       FINISH commits all Oracle CODASYL DBMS databases. A commit is
       not done until you finish the last Oracle CODASYL DBMS record or
       domain.

       For relational sources, when the last domain or relation is
       finished, a commit is performed and no collections are retained.

       Format

                 [ ALL                            ]
                 [ [ domain-name        ]         ]
         FINISH  [ [                    ] [,...]  ]
                 [ [ dbms-record-name   ]         ]
                 [ [ rdb-relation-name  ]         ]
                 [                                ]

1  –  Arguments

    ALL

       Ends your control over all readied domains, relations, Oracle
       CODASYL DBMS records, and all domain or dictionary tables loaded
       in your workspace.

    domain-name

       Is the given name of a readied domain or domain table you want
       to finish. If you specify the names of more than one domain or
       domain table, separate each from the next with a comma (,).

    rdb-relation-name

       Is the given name of a readied relation you want to finish. If
       you specify the names of more than one relation, separate each
       from the next with a comma (,).

    dbms-record-name

       Is the given name of a Oracle CODASYL DBMS record readied with
       the READY database command. If you specify the names of more than
       one record, separate each from the next with a comma (,).

2  –  Example

       The following example releases control of the domain YACHTS:

       DTR> SHOW READY
       Ready sources:
          YACHTS:  Domain, RMS indexed, protected read
                  <CDD$TOP.DTR$LIB.DEMO.YACHTS;1>
       No loaded tables.

       DTR> FINISH YACHTS
       DTR> SHOW READY
       No ready sources.
       No loaded tables.
       DTR>
Close Help