DTRHELP.HLB  —  Commands Statements Clauses, DEFINE DOMAIN Command, Examples
       Define the CDD$DATABASE domain NEWYACHTS. Use the already defined
       CDD$DATABASE YACHTS.

       DTR> DEFINE DOMAIN NEWYACHTS USING YACHTS_DB
       DFN> WITH RELATIONSHIPS;

       Define the Oracle CODASYL DBMS domain EMPLOYEES. The name of the
       record-type is EMPLOYEE, and the name of the database instance is
       PARTS_DB. The domain definition includes the FORM clause.

       DTR> DEFINE DOMAIN EMPLOYEES
       DFN>     USING EMPLOYEE OF DATABASE PARTS_DB
       DFN>     FORM IS EMPFOR IN FORMS:PARTS.FLB;
       DTR>

       Define a network domain called REMOTE_YACHTS:

       DTR> DEFINE DOMAIN REMOTE_YACHTS USING
       DFN>    CDD$TOP.DTR$LIB.DEMO.YACHTS AT
       DFN>    VAX32"SMITH ADRIENNE" FORM IS YACHT1 IN DTRFRM;
       DTR>

       The following example defines a DEC DATATRIEVE domain that
       automatically uses a form. The domain is defined for the relation
       EMPLOYEES.

       DTR> DEFINE DOMAIN EMPLOYEES
       DFN>     USING EMPLOYEES OF DATABASE PERSONNEL
       DFN>     FORM IS EMPFOR IN FORMSLIB;
       DTR>

       Define the domain PHONES. Use the record definition PHONE_REC
       that is cataloged in the directory CDD$TOP.DEPARTMENT. Specify
       PHONE.DAT as the data file:

       DTR> DEFINE DOMAIN PHONES USING
       DFN> CDD$TOP.DEPARTMENT.PHONE_REC ON PHONE.DAT;
       DTR>

       Define a view of yacht and owner information:

       DTR> SHOW BOAT_VIEW
       DOMAIN BOAT_VIEW OF YACHTS, OWNERS USING
       01 BOAT_INFO OCCURS FOR YACHTS.
          03 TYPE FROM YACHTS.
          03 SKIPPERS OCCURS FOR OWNERS WITH TYPE EQ BOAT.TYPE.
             05 NAME FROM OWNERS.
             05 BOAT_NAME FROM OWNERS.
       ;

       DTR> READY BOAT_VIEW
       DTR> PRINT FIRST 4 BOAT_VIEW

                                                BOAT
       MANUFACTURER   MODEL       NAME          NAME

        ALBERG      37 MK II
        ALBIN       79
        ALBIN       BALLAD
        ALBIN       VEGA       STEVE      DELIVERANCE
                               HUGH       IMPULSE

       DTR>

       You can use a view domain such as BOAT_VIEW as a source for
       modifying data in a domain based on a RMS file.
Close Help