The DROP CATALOG statement
allows you to drop a catalog by using this syntax:
DROP CATALOG "catalog" [ drop-disposition ]
“catalog”
Specifies the catalog
name.
drop-disposition
Specifies the drop
disposition and is one of the following values:
drop-disposition ::=
{RESTRICT | CASCADE} [FORCE]
| RESTRICT |
Specifies that the drop target is empty. This is
the default value.
|
| CASCADE |
Specifies that contained objects are dropped. |
| FORCE |
Specifies the optional FORCE keyword that will suppress
error messages when the data service does not exist. This additional
option does not affect the performance of the RESTRICT or CASCADE
options.
|
drop catalog "catalog1_BASE" cascade