DTRHELP.HLB  —  Commands Statements Clauses, DEFINE DOMAIN Command
       Stores a domain definition in the Oracle CDD/Repository data
       dictionary system.

       The following sections explain how to define domains for
       CDD$DATABASE objects, Oracle CODASYL DBMS databases, network
       domains based on domains residing at other DECnet[TM] nodes,
       domains based on relational databases, domains based on single
       RMS files, and views based on one or more domains.

       Format

         To define a CDD$DATABASE domain, use the following syntax:

         DEFINE DOMAIN  domain-name  [USING]  database-name

             [FORM [IS] form-name [IN] file-name [USING exchange-rec]]

             [WITH]  RELATIONSHIPS ;

         To define a Oracle CODASYL DBMS domain, use the following
         syntax:

         DEFINE DOMAIN  domain-name  [USING]  record-name

             [OF]  [DATABASE]  database-path-name

             [FORM [IS] form-name [IN] file-name [USING exchange-rec]] ;

         To define a network domain, use the following syntax:

         DEFINE DOMAIN  domain-name [USING] remote-path-name AT
                        node-spec

             [FORM  [IS]  form-name  [IN] file-name [USING exchange-rec]]

             [[WITH] RELATIONSHIPS] ;

         To define a relational domain, use the following syntax:

         DEFINE DOMAIN  domain-name [USING] relation-name

             [OF]  [DATABASE]  database-path-name

             [FORM [IS] form-name [IN] file-name [USING exchange-rec]]

             [[WITH] RELATIONSHIPS] ;

         To define a domain based on a RMS file, use the following
         syntax:

         DEFINE DOMAIN  path-name [USING] record-name ON file-spec

             [FORM [IS] form-name [IN] file-name [USING exchange-rec]]

             [[WITH]  RELATIONSHIPS] ;

       To define a view domain, use the following syntax:

       DEFINE DOMAIN view-path-name OF domain-name-1 [,...][BY   ]
               [USING]

           level-number-1  field-name-1    OCCURS FOR rse-1.

           level-number-2  field-name-2  { OCCURS FOR rse-n        } .
             { FROM domain-name-n }

             .         .                   .
             .         .                   .
             .         .                   .

           [FORM [IS] form-name [IN] file-name [USING exchange-rec]]

           [[WITH] RELATIONSHIPS] ;
Additional Information: explode extract
Arguments Examples
Close Help