Need example for VSAM File subset where clause to specify field not empty string

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Currently I'm trying to mask a field with a fixed field value only when the field has a value.    I don't know that this is valid.   How to do say only when it is  NOT Blank do we want to setup the fixed value.

BROWSE    TSTT.TDMNEW.ALL.DEFCSV(BRSPTRFR)            Command ===>                                         3,TRFR_LST_PROC_DATE,5,134,2,"PackedSigned:9,0",,,,,,, 3,USER_ID,8,139,2,String,,,,,,,                       3,SUPERVISOR_ID,8,147,2,String,,,,,,,                 3,START_DATE_TIME,26,155,2,String,,,,,,,              3,COMP_DATE_TIME,26,181,2,String,,,,,,,

BROWSE    TSTT.TDMNEW.ALL.MAPCSV(BRSPTDSA)                                    Command ===>                                                                 *********************************************************** Top of Data ****** "Table","Column","Function","Parm1","Parm2","Parm3","Parm4","KeepNulls","Datef DCLBRSPTDSA,FROM_SHORT_NAME,FORMATENCRYPT,,,,,N,,,,,,,,,,,,,,,                DCLBRSPTDSA,PLAN_HOLDER,FORMATENCRYPT,,,,,N,,,,,,,,,,,,,,,                    DCLBRSPTDSA,USER_ID,FIXED,TRSP01,,,,N,,,,,,,,,,,,,,,                          DCLBRSPTDSA,,WHERE," SUPERVISOR_ID NOT = ' '",,,,,,,,,,,,,,,,,,,              DCLBRSPTDSA,SUPERVISOR_ID,FIXED,TRSP02,,,,N,,,,,,,,,,,,,,,                    ********************************************************** Bottom of Data ****

Environment

Release : 6.0

Component : CA Test Data Manager - Others

Cause

DCLBRSPTDSA,,WHERE," SUPERVISOR_ID NOT = ' '",,,,,,,,,,,,,,,,,,,             

Please note that the Single Quotes had a <SPACE> between them.

The next correction was in the order of the verbiage:

DCLBRSPTDSA,,WHERE," NOT SUPERVISOR_ID = ''",,,,,,,,,,,,,,,,,,,  

Resolution

DCLBRSPTDSA,,WHERE," NOT SUPERVISOR_ID = ''",,,,,,,,,,,,,,,,,,,    

The above works.