Filter
Top Products
with an alphabetic character.
A scope name is unique in a database.
DSI name list
Specify the DSI names of tables whose access range is limited as DSI name lists. Each DSI name must be unique in
the database. A DSI that is the same as that of the scope definition statement cannot be specified.
Caution:
Limiting a data manipulation range with the scope function is only effective for SQL statements of an application
program or rdbupt command. It is not effective for RDB commands such as rdbsloader.
2.8 Applying a Storage Structure Definition
This section explains how to apply a storage structure definition. Application of storage structure definition involves
application of scope definition.
2.8.1 Scope definition application
A scope definition is applied by using the APPLY SCOPE statement. A scope definition can be applied to a user to limit
the range of items in a table that the user is allowed to manipulate.
The executor of the APPLY SCOPE statement must be the user who defined the scope.
A sample scope application follows.
Example:
Apply scope TOKYO to user SUZUKI.
Scope name
Specify the name of the scope applied to the table user with up to 36 alphanumeric characters beginning with an
alphabetic character.
A scope name must be defined by the CREATE SCOPE statement.
A scope name is unique in a database.
Privilege identifier
Specify the user identifier of the scope user.
2.9 Simplifying a Storage Structure Definition
This section explains how to simplify a storage structure definition.
When defining a storage structure in a simplified form, use table or index definition. In a table or index definition,
specify a database space to store data. SymfoWARE/RDB automatically defines a storage structure according to the
specification. In this case, the table storage structure is set to SEQUENTIAL and the index storage structure is set to
BTREE. For a multimedia data storage table, SEQUENTIAL or OBJECT can be selected as the table storage
structure; however, split storage is not available.
If a storage structure is defined in a simplified form, DSO and DSI of the table are automatically named in accordance
with the table or index definition. The data length and allocation size are then also automatically determined.
66