Removing an Object Set for Multiple Members Source Physical File

The stored procedure is in the DB2® schema to remove an object set for multi-member source physical file.

RMV_SRCPF_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

This procedure allows a user to remove an object set of multi-member source physical file (MMPF).

remove an object set for multi-member source physical file:

>>-RMV_SRCPF_OBJECT-SET -(---SRCPF_LIB----------->
>-------- SRCPF_NAME ------)-------------------------------------><

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

Parameter

SRCPF_LIB: This parameter means an absolute library which contains the source physical files.; The library name should be absolute and should not contain any regular expressions.; The data type for this parameter is VARCHAR(10)
SRCPF_NAME: This parameter means an absolute source physical file which can have one or more members, all the members in the source physical file will be indexed. The file name should be absolute and should not contain any regular expressions.; *ALLSRCPF; If *ALLSRCPF was specified as source physical name, it means will remove the object set for all the source physical files in SRCPF_LIB.; The data type for this parameter is VARCHAR(10)

Result Note

In following case remove will failed due to object set not found:

>User inputs incorrect SRCPF_LIB or SRCPF_NAME
>Specifies SRCPF_LIB/SRCPF_NAME corresponding object set has been deleted previously.

User will get error message show that the object set doesn’t exist with the specific attribute.

QUERY_OBJECT_SET() returns the object set list and the input parameters. User can specify correct input parameters while invoking this stored procedure to remove the object set.

Examples

Remove an object set in MYCOLLECTION for the multi-member source physical file QCSRC in library ISVSQLLP:

> CALL MYCOLLECTION.RMV_SRCPF_OBJECT_SET('ISVSQLLP','QCSRC');

Remove an object set in MYCOLLECTION for all the multi-member source physical files library ISVSQLLP:

> CALL MYCOLLECTION.RMV_SRCPF_OBJECT_SET('ISVSQLLP','*ALLSRCPF');