DROP CLUSTER (Adabas Only)
Function
This statement deletes the logical and physical representation of a cluster.
Warning:
Dropping a cluster causes all the data contained within to be destroyed. Once the statement has been executed, there is no way to recover the data.
Syntax
DROP CLUSTER cluster_specification [ | CASCADE | RESTRICT]
where cluster_specification is a schema identifier and table identifier of the master table in the cluster that you want to drop. The default schema name is assumed if not specified here. See
Cluster Specification.
Description
A cluster and all associated information will be deleted from Adabas SQL Gateway Embedded SQL's catalog and the underlying Adabas file will be deleted. Any other statements referencing this table will no longer be valid. In addition, any attempts to compile statements which reference this table will fail. Even if the table is re-specified, all previously compiled statements remain invalid.
If the CASCADE option is specified, all view descriptions based on the cluster to be dropped will be deleted as well.
If the RESTRICT option is specified, the statement execution will be rejected if there are dependent views.
If neither of these two options is specified, RESTRICT is assumed.
Limitations
The DBA can execute this statement for all users. All other users can use this statement only in a schema owned by the user.
The specified table specification must denote an existing cluster at runtime.
Warning:
This statement is not subject to transaction logic. An implicit COMMIT will be performed after successful execution of this statement. If an error is detected during execution of this statement, an implicit ROLLBACK will be performed. Therefore, before executing this statement, it is strongly recommended to complete any open transaction containing INSERT, UPDATE and/or DELETE statements by issuing an explicit COMMIT or ROLLBACK statement.
ANSI Specifics
The DROP CLUSTER statement is not part of the ANSI standard.
Examples
The following example deletes all data and data structures of the cluster city_guide and all related views:
DROP CLUSTER city_guide CASCADE;