Data Source DB2/zOS version v12 FL501
Verified in FDM SW version 4.10.2
All attempts to use the HASHLOV function with a list of dates always result in an unhandled error.
The tests were performed providing the dates in different formats (YYYYMMDD, YYYY-MM-DD, DD / MM / YYYY, ...), but the result was always the same:
java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Date
Release : 4.10
Component : Fast Data Masker
Identified as product defect.
Issue has been fixed via patch build which can downloaded from below link:
Follow Fast Data Masker section of below article to apply the patch build.