CIA Service Functions › CAISEC.CIA_FILTER_MATCH Table Function › CAISEC.CIA_FILTER_MATCH: Example

CAISEC.CIA_FILTER_MATCH: Example

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

SELECT SYSID, RESCLASS, RULEKEY, RESMASK, NEXTKEY, APPIND
FROM       
TABLE(CAISEC.CIA_FILTER_MATCH('TESTUSR.NEXTKEY','DATASET','%','NOPREFIX'))
AS PI1;