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

CIASEC.CIA_SCOPERES_MATCH: Returned Columns

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

SYSID VARCHAR(8) 
ROLEID VARCHAR(24) 
EXPDATE DATE 
ACTDATE DATE 

CAISEC.CIA_ROLEINFO_MATCH: Example

This example SQL statement uses the function in a FROM clause:

SELECT * 
FROM 
TABLE(CAISEC.CIA_ROLEINFO_MATCH('     T   ','%')) 
AS PI1;