Fujitsu UDS/SQL V2.5 사용자 설명서

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

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