It's been a lot of years since I used UniData. Bringing up a DB for personal use in Rocket Software's version. But I'm really struggling with queries. Here's a case in point:
We have a multi-value file, MBR.FILE:
LIST MBR.FILE MBR_UMID MBR_NM MBR_GK_BD MBR_GK_ED GK_ADJ_CD LOB_CLASS PROD_LOB PROD_BD WHEN PROD_LOB = "MER" AND WHEN GK_ADJ_CD = "" AND WHEN MBR_GK_ED = ""
This query fails to respect the "WHEN" filters and shows all lines, leaving the WHEN referenced attributes blank in the lines that should be filtered out.
Any help would be appreciated
Sounds like you need to use a combination of BY.EXP and WHEN ASSOCIATED. This will normalize your multivalues select against your filters and only display the values you want to see.
Good idea to check your DICT to ensure the mv's you're using are all associated.