Removing an Object Set

This stored procedure will remove an object set from a text search collection.

REMOVE_OBJECT_SET

Authorization

This stored procedure is created with public authority *EXCLUDE and is owned by the creator of the text search collection.

The procedure will adopt the authority of the text search collection owner's profile. Authority can be granted to other users to allow them to execute the procedure.

Syntax

Read syntax diagramSkip visual syntax diagram REMOVE_OBJECT_SET(setid)

The schema qualifier is the name of the text search collection.

Parameters

setid
The set id which was obtained when adding object set.

The object set ID can also be obtained using the QUERY_OBJECT_SET stored procedure after the object set has been added.

The data type for this parameter is INTEGER.

Examples

Remove object set #1 from collection MYCOLLECTION.
> CALL MYCOLLECTION.remove_object_set(1)

To remove an object set from a collection from IBM® Navigator for i, follow these steps.

  1. From IBM Navigator for i, expand IBM i Management > System > All Tasks.
  2. On the right panel, select System > OmniFind > Collection List.
  3. Right click the collection and select Properties. On the Object tab, press Remove button.