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>