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

CAISEC.CIA_RESOURCE_MATCH: Example

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

SELECT SYSID, RESCLASS, RULEKEY, RESMASK, NETXKEY, APPIND
 FROM
 TABLE(CAISEC.CIA_RESOURCE_MATCH('SYS1.PARMIB','DATASET','%','NOPREFIX'))
 AS PI1;