CIA Service Functions › CAISEC.CIA_SCOPERES_MATCH Table Function

CAISEC.CIA_SCOPERES_MATCH Table Function

This function returns rows from the SCPRES table that matches the input parameters of the function.

The schema is CAISEC.

Syntax

This function has the following format:

CAISEC.CIA_SCOPERES_MATCH(in-resource, in-resource-type, in-resource-sysid, in-prefix)

Return Values

This function returns the following values:

RETURNS TABLE(sysid ,scopeid, resclass, resmask, scptype, masktype, appind)

Parameters

This function has the following parameters:

in-resource

Defines the name of a resource used for matching resource masks in the SCPRES table. The name can be either a full name or a partial name (prefix). The data type is VARCHAR.

Limits: Maximum length 256 bytes

in-resource-type

Defines the resource class or type of the input resource. The data type is VARCHAR.

Limits: Maximum length 8 bytes

in-resource-sysid

Defines a sysid used to limit results to the systems in question. This parameter accepts SQL wildcard characters (% and _) for pattern matching. The data type is VARCHAR.

Limits: Maximum length 8 bytes

in-prefix

Specifies whether the in-resource parameter is a full or partial resource name. Valid values are PREFIX or NOPREFIX. PREFIX specifies that the in-resource parameter is the beginning of a resource name, and matches any resource masks in the PERMXREF table that begin with this prefix. NOPREFIX specifies that the in-resource parameter is a full resource name and only resource masks that match the entire name are returned. The data type is VARCHAR.

Limits: Maximum length 8 bytes