CIA Service Functions › CAISEC.CIA_RESOURCE_MATCH Table Function › CAISEC.CIA_RESOURCE_MATCH: Example Result

CAISEC.CIA_RESOURCE_MATCH: Example Result

---------+---------+---------+---------+---------+---------+------------+--

SYSID     RESCLASS  RULEKEY     RESMASK          NEXTKEY        APPIND

---------+---------+---------+---------+---------+---------+------------+--

XE61      DATASET   DSNPOST     *-.-                               A     
XE61      DATASET   NOBROWN1    *-.-             NOBROWN2          A     
XE61      DATASET   NOBROWN2    *-.-             NOBROWN3          A     
XE61      DATASET   NOBROWN3    *-.-             NOBROWN4          A     
XE61      DATASET   NOBROWN4    *-.-             NOBROWN5          A     
XE61      DATASET   NOBROWN5    *-.-                               A     
XE61      DATASET   PRODSYS     SYS1.PARMLIB                       A    
XE61      DATASET   PRODSYS     SYS1.-                             A    
XE61      DATASET   RSPA        -.-.-                              A     
XE31      DATASET   ++          ++                                 T    
XE31      DATASET   *.          *.*.*.%                            T    
XE31      DATASET   *.          *.*.*.%                            T    
XE31      DATASET   *.          *.*.*.SYSTEM12                     T    
XE31      DATASET   *.          *.*.*.SYSTEM22                     T    
XE31      DATASET   *.          *.*.SYSTEM12                       T    
XE31      DATASET   *.          *.*.SYSTEM22                       T    
XE31      DATASET   **          **                                 T    
XE31      DATASET   %.          %.*                                T    
XE31      DATASET   %.          %.*****                            T    
XE31      DATASET               SYSSYS1.PARMLIB                    T    
XE31      DATASET               SYSSYS1.PARMLIB                    T  

CAISEC.CIA_ROLEINFO_MATCH Table Function

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

The schema is CAISEC.

Syntax

This function has the following format:

CAISEC.CIA_ROLEINFO_MATCH(in-uid, in- uid -sysid)

Return Values

This function returns the following values:

RETURNS TABLE(sysid ,roleid, expdate, actdate) 

Parameters

This function has the following parameters:

in-uid

Defines the uid used for matching uid masks in the ROLEINFO table. The data type is VARCHAR.

Limits: Maximum length 24 bytes

in-uid-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