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