Query Object Set Information

QUERY_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

None

RESULT SET RETURNED

The procedure returns a result set that has one row for each object set:

SETID             INTEGER
SETSTATE          CHAR(10)      CCSID 1208 
LASTREFRESHTIME   TIMESTAMP
ADDOBJSETSQL      VARCHAR(2000) CCSID 1208

SETID - A unique identifier assigned to each object set. This identifier may be used on the remove_object_set stored procedure to remove the object set from the collection.

SETSTATE - The state of the object set. This is reserved for future expansion and is always 'ACTIVE'.

LASTREFRESHTIME - The last time the object set has been refreshed to reflect objects actually on the system.

ADDOBJSETSQL - The SQL stored procedure call that was used to add this object set.

Examples

Call MYCOLLECTION.QUERY_OBJECT_SET;