CAISEC.CIA_FILTER_MATCH Not Returning Expected Results.

Document ID : KB000046856
Last Modified Date : 14/02/2018
Show Technical Document Details

Questions:

When selecting authid, resmask, noprefix from table(CAISEC.CIA_FILTER_MATCH('ABCD','OTRAN','%','PREFIX')), the following is returned:

AUTHID RESMASK NOPREFIX
-------------------------------------------------------------
PRODDEPT ABCD 
TESTDEPT -FGH 
TESTDEPT -IJK 

Why is -FGH and -IJK returned?

Answer:

Because OTRANS '-FGH'  and '-IJK' is owned and CIA cannot tell that the '-' is a floating point wild card masking character on a prefixed resource. This is not a bug.

The enhancement to have this changed has been accepted and will be added to a future level.