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
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.
- From IBM Navigator for i, expand IBM i Management > System > All Tasks.
- On the right panel, select System > OmniFind > Collection List.
- Right click the collection and select Properties. On the Object tab, press Remove button.