I have followed below steps and masking functions.
1. Created connection Profile to connect to DB.
2. Tried masking functions( FORMATENCRYPT, RANDOMBLOB, FORMATHASH) to mask BLOB column data.
While running the masking, received below error:
Illegal conversion: can not convert from "java.lang.String" to "java.sql.Blob" ERRORCODE=-4474, SQLSTATE=null
Data source connection: DB2
OS: Linux
FDM
Fast data Masker
TDM
Test Data Manager
Since there is string data in the BLOB column, you are getting a type casting error as "Illegal conversion: can not convert from "java.lang.String" to "java.sql.Blob" ERRORCODE=-4474, SQLSTATE=null ".
Please insert some image files or text files in BLOB column and apply the masking using the RANDOMBLOB function.