DB2 10.5 for Linux, UNIX, and Windows

WLM_DROP_MEMBER_SUBSET procedure - Drop a member subset object

The WLM_DROP_MEMBER_SUBSET procedure drops an existing member subset database object.

Authorization

One of the following authorizations is required:
  • DBADM authority
  • WLMADM authority

Default PUBLIC privilege

None

Syntax

Read syntax diagramSkip visual syntax diagram
>>-WLM_DROP_MEMBER_SUBSET--(--subset_name--)-------------------><

The schema is SYSPROC.

Routine parameters

subset_name
An input argument of type VARCHAR(128) that specifies the name of the member subset object to be dropped. This is a one-part name. It is an SQL identifier (ordinary or delimited). The name must identify a member subset which already exists in the current database (SQLSTATE 42704). This argument cannot be NULL (SQLSTATE 42815).

Usage notes

  • As an autonomous procedure, WLM_DROP_MEMBER_SUBSET executes in its own transaction scope.
  • When WLM_DROP_MEMBER_SUBSET successfully completes, it will commit the work performed within the procedure, but if it is unsuccessful, the procedure rolls back any work performed.

Example

Drop the member subset MY_SUBSET. 
   CALL SYSPROC.WLM_DROP_MEMBER_SUBSET( 'MY_SUBSET' )