You cannot cast a BLOB to a string by DB2 SQL directly, at least unable to do it now by the CAST function.

in Casting between data types, we can see when taking BLOB or BINARY as Cast from data type, VARCHAR and CLOB are both not available.