Filter
Top Products
A simplified storage structure definition dynamically extends the DSI capacity.
The prefix for naming, the data length, the allocation size, and the DSI capacity extension can be changed by using
parameters in the operating environment file. For a multimedia data storage table, the storage structure can be
selected. For information about the operating environment file, refer to the "RDB User's Guide: Application Program
Development."
2.9.1 Table definition
In a table definition, specify a data space as a storage area for table data. When a storage area is specified, the table
DSO and DSI are automatically defined. In addition, DSI is automatically initialized.
Storage area specification
Specify a database space as a storage area for actual table data. If a storage area is specified, the table and schema
names should be specified using up to 8 alphanumeric characters beginning with an alphabetic character.
If DEFAULT_DSI_NAME=CODE is specified in the system operating environment file, however, the table and schema
names may be specified using up to 36 alphanumeric characters beginning with an alphabetic character.
The example below defines a base table for an stock management database with a storage structure. Define an
STOCK table belonging to schema STOCKS.
Example:
CREATE TABLE statement defining an STOCK table (with storage area specification)
The above specification has the following definitions:
Table DSO and DSI names
DSO and DSI of a table are named by combining schema and table names in a table definition. The DSO and DSI
names are the same.
67