Previous Topic: CAISEC.CIA_FILTER_MATCH: Example ResultNext Topic: CAISEC.CIA_RESOURCE_MATCH: Returned Columns

CIA Service Functions › CAISEC.CIA_RESOURCE_MATCH Table Function

CAISEC.CIA_RESOURCE_MATCH Table Function

This function returns rows from the PERMXREF table that match the input parameters of the function.

The schema is CAISEC.

Syntax

This function has the following format: 

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

Return Values

This function returns the following values: 

RETURNS TABLE(sysid, resclass, rulekey, authid, seqnum, resmask, noprefix, prefix, nextkey, authtype, append, adminby, admindate, admintime, active, until, acc-read, acc-write, acc-allocate, acc-add, acc-update, acc-delete, acc-execute, acc-all, acc-alter, acc-alterin, acc-bind, acc-copy, acc-create, acc-createin, acc-cretab, acc-crets, acc-dbadm, acc-dbcntl, acc-dbmaint, acc-dispdb, acc-drop, acc-dropin, acc-imagecopy, acc-index, acc-insert, acc-load, acc-packadm, acc-recovdb, acc-refer, acc-reorg, acc-repair, acc-select, acc-startdb, acc-stats, acc-stopdb, acc-trigger, acc-usage, actn-audt, actn-exit, actn-fail, actn-ntfy, actn-vrfy, actn-nods, mode, ddname, volume, dayrecid, timerecid, srcrecid, data, db2sysid)

Parameters

This function has the following parameters:

in-resource

Defines the name of a resource used for matching resource masks in the PERMXREF 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