Filter
Top Products
Deleting a table DSO definition (DROP DSO statement)
To delete a table DSO definition from a base table, use the DROP DSO statement. If an index DSO or a table DSI has
been defined for the DSO to be deleted, the relevant DSO definition cannot be deleted. All related index DSO
definitions or table DSI definitions must be deleted in advance.
However, if the user specifies CASCADE, all DSIs related to the DSO to be deleted are deleted.
An example of deleting a table DSO definition follows.
Example:
Delete all table DSOs belonging to STOCKMN_DB.
Adding an index DSO definition (CREATE DSO statement)
To add an index DSO definition for a base table for which the table DSO has already been defined, use the CREATE
DSO statement. An example of adding an index DSO definition follows. For details about how to specify the CREATE
DSO statement, see 2.7 "Defining a Storage Structure."
Example:
Add STOCKNO_IXDSO as the index DSO for the WHCODE column of the STOCK table.
Deleting an index DSO definition (DROP DSO statement)
To delete an index DSO definition from a base table, use the DROP DSO statement.
If an index DSI has been defined, the relevant index DSO definition cannot be deleted. All related index DSI definitions
must be deleted in advance.
However, when CASCADE is specified, if the DSO to be deleted is for a base table, all related index DSOs and
related DSIs are deleted.
An example of deleting an index DSO definition follows.
Example:
Delete all index DSOs belonging to STOCKMN_DB.
124