CIA Service Functions › CAISEC.CIA_RESOURCE_MATCH Table Function › CAISEC.CIA_RESOURCE_MATCH: Returned Columns

CAISEC.CIA_RESOURCE_MATCH: Returned Columns

This function returns a CIA table with the following columns. Some column values can be null.

SYSID         VARCHAR(8)  
RESCLASS      CHAR(8)     
RULEKEY       VARCHAR(256)
AUTHID        CHAR(24)    
SEQNUM        SMALLINT    
RESMASK       VARCHAR(256)
NOPREFIX      CHAR(1)     
PREFIX        VARCHAR(40) 
NEXTKEY       VARCHAR(40) 
AUTHTYPE      CHAR(1)     
APPIND        CHAR(1)     
ADMINBY       CHAR(8)     
ADMINDATE     DATE        
ADMINTIME     TIME        
ACTIVE        DATE        
UNTIL         DATE        
ACC_READ      CHAR(1)     
ACC_WRITE     CHAR(1)     
ACC_ALLOCATE  CHAR(1)     
ACC_ADD       CHAR(1)     
ACC_UPDATE    CHAR(1)     
ACC_DELETE    CHAR(1)     
ACC_EXECUTE   CHAR(1)     
ACC_ALL       CHAR(1)     
ACC_ALTER     CHAR(1)     
ACC_ALTERIN   CHAR(1)     
ACC_BIND      CHAR(1)     
ACC_COPY      CHAR(1)     
ACC_CREATE    CHAR(1)     
ACC_CREATEIN  CHAR(1)     
ACC_CRETAB    CHAR(1)     
ACC_CRETS     CHAR(1)     
ACC_DBADM     CHAR(1)     
ACC_DBCNTL    CHAR(1)     
ACC_DBMAINT   CHAR(1)     
ACC_DISPDB    CHAR(1)     
ACC_DROP      CHAR(1)     
ACC_DROPIN    CHAR(1)     
ACC_IMAGECOPY CHAR(1)     
ACC_INDEX     CHAR(1)    
ACC_INSERT    CHAR(1)    
ACC_LOAD      CHAR(1)    
ACC_PACKADM   CHAR(1)    
ACC_RECOVDB   CHAR(1)    
ACC_REFER     CHAR(1)    
ACC_REORG     CHAR(1)    
ACC_REPAIR    CHAR(1)    
ACC_SELECT    CHAR(1)    
ACC_STARTDB   CHAR(1)    
ACC_STATS     CHAR(1)    
ACC_STOPDB    CHAR(1)    
ACC_TRIGGER   CHAR(1)    
ACC_USAGE     CHAR(1)    
ACTN_AUDT     CHAR(1)    
ACTN_EXIT     CHAR(1)    
ACTN_FAIL     CHAR(1)    
ACTN_NTFY     CHAR(1)    
ACTN_VRFY     CHAR(1)    
ACTN_NODS     CHAR(1)    
MODE          CHAR(1)    
DDNAME        CHAR(8)    
VOLUME        CHAR(6)    
DAYRECID      CHAR(12)   
TIMERECID     CHAR(12)   
SRCRECID      CHAR(8)    
DATA          VARCHAR(64)
DB2SYSID      CHAR(4)