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>