drop dbspace argument: Drop a dbspace (SQL administration API)

Use the drop dbspace argument with the admin() or task() function to drop the specified dbspace.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"drop dbspace"--------------->
                     '-task--'                      

>--,--"dbspace"--)--;------------------------------------------><

Element Description Key Considerations
dbspace The name of the dbspace to drop. The dbspace must exist.

Before you drop a dbspace, drop all databases and tables that you previously created in the dbspace.

Usage

This function is equivalent to the onspaces -d command.

Example

The following example drops the dbspace named dbspace4:

EXECUTE FUNCTION task("drop dbspace","dbspace4");

Copyright© 2019 HCL Technologies Limited