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.