Previous Topic: About Table FunctionsNext Topic: CAISEC.CIA_RESOURCE_MATCH: Returned Columns

CIA Service Functions › CAISEC.CIA_FILTER_MATCH Table Function

CAISEC.CIA_FILTER_MATCH Table Function

The CAISEC.CIA_FILTER_MATCH table function returns rows from the PERMXREF table that match the input parameters of the function. It calls the CAISEC.CIA_RESOURCE_MATCH function and filters the table rows that it returns. CA Top Secret related rows are returned without further filtering.

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

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 )

The schema is CAISEC.

in-resource

Specifies 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 of 256 bytes

in-resource-type

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

Limits: Maximum length 8 bytes

in-resource-sysid

Specifies 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

Indicates whether the in-resource parameter is a full or partial resource name. Valid values are PREFIX or NOPREFIX. PREFIX indicates that the in-resource parameter is the beginning of a resource name, and will match any resource masks in the PERMXREF table that begin with this prefix. NOPREFIX indicates 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