Server User Manual

Adding a table DSI definition (CREATE DSI statement)
To add a table DSI definition for a base table for which the DSO has been defined, use the CREATE DSI statement.
Specify each item of the CREATE DSI statement in a similar manner as when defining the storage structure.
An example of adding a table DSI definition follows. For details about how to specify the CREATE DSI statement, see
2.7 "Defining a Storage Structure".
Example:
Add EAST_ORDER_DSI to STOCKMN_DB. EAST_ORDER_DSI is subordinate to ORDER_DSO and
is defined on the database space named DBSP_3.
Deleting a table DSI definition (DROP DSI statement)
To delete a DSI definition from a base table, use the DROP DSI statement. If the DSI to be deleted is a table DSI, and
an index DSI related to it exists, the relevant DSI definition cannot be deleted. All DSI definitions of related index DSIs
must be deleted in advance.
However, when CASCADE is specified, if the DSI to be deleted is a table DSI, all related index DSIs are deleted.
An example of deleting a DSI definition follows.
Example:
Delete all DSIs belonging to STOCKMN_DB.
125