Looking for GG colconversion function to exclude specific rows
Hi,
I need your help to add the filter condition to the below map statement. I am not getting any function to exclude the specific numbers and your help is very much appreciated.
Filter condition: Exclude any rows where msg_queue_id is either 107 or 108.
Map statement :
MAP TFAADM.TWFA0040_HV_TB_QUEUE_TRKG, TARGET FGAPP.TWFA0040_HV_TB_QUEUE_TRKG, FILTER ( ON UPDATE, @VALONEOF (DATA_STAT_CDE, "R","E","N")), FILTER ( ON INSERT, @COLTEST (PROC_STAT_CDE,NULL) ), REPERROR (1403, DISCARD);
~Suresh