Specifies the repository path name of a repository field
definition. SQL creates the domain using the definition from
this field and gives the domain the name of the field definition.
Creating a domain based on a repository domain definition is
useful when many applications share the same definition. Changes
to the common definition can be automatically reflected in all
applications that use it.
You can create a domain using the FROM path-name clause only if
the field definition in the repository was originally created
using the repository CDO utility. For instance, you cannot create
a domain using the FROM path-name clause if the definition was
created in the repository as part of an SQL session. Oracle
Rdb requires that the field names referenced in the VALID IF
expression of the CDO utility match the name of the global field
being defined or changed.
NOTE
Changes by other users or applications to the field
definition in the repository will affect the domain
definition once the database is integrated to match the
repository with an INTEGRATE DATABASE . . . ALTER FILES
statement.
You can use the FROM path-name clause only if the database was
attached specifying PATHNAME. You can specify either a full
repository path name or a relative repository path name.
You cannot specify formatting clauses when you use the FROM path-
name form of the CREATE DOMAIN statement.
You cannot use the FROM path-name clause when embedding a CREATE
DOMAIN statement in a CREATE DATABASE statement.