AW DETACH

The AW DETACH command removes a workspace from the workspace list. When you remove the first workspace, the second workspace becomes the current workspace (unless it is the EXPRESS workspace). When you detach a workspace, changes that were made before an UPDATE was issued remain in the database and become permanent with the next COMMIT. When changes were made after the UPDATE was issued, they are discarded.

Note:

When a program named TRIGGER_AW exists in the analytic workspace, the execution of an AW DETACH statement automatically executes that program.

Syntax

AW DETACH workspace

Arguments

workspace: The name of the analytic workspace. You can specify either a workspace name or a workspace alias, depending on the keywords you are using.

Examples

Detaching a Workspace

You can use the AW command with the DETACH keyword to detach a workspace.

AW DETACH expense