Fujitsu UDS/SQL V2.5 Network Router User Manual


 
Subschema DDL User interface
194 U929-J-Z125-9-76
6.1.7 Copying realms from the schema into the subschema
Format 1:
COPY ALL AREAS.
Format 2:
COPY realm-name,... .
Format 1 is used if all the realms in the schema are to be copied into the subschema.
Format 2 is used if only some of the realms in the schema are to be copied into the
subschema.
realm-name specifies the realms to be copied. All realms that contain data relating to the
record types and sets of the subschema and that the subschema user requires, must be
copied. The table 13 indicates which realms this may be. When SQL is used, the temporary
realm must always be copied.
Type of data Realm(s) from
Records WITHIN clauses (DDL)
DBTTs DBTT clauses
Hash areas for primary keys Record POPULATION clauses (SSL)
Hash areas for record secondary keys
Record INDEX clauses (SSL)
Record SEARCH key tables
Pointer arrays
MODE clauses (SSL)
Lists
Sort key tables
Set SEARCH key tables Set INDEX clauses (SSL)
Hash areas for set secondary keys
Table 13: Realms to be copied