Incorrect query generation for cast integer to string for DB2 row validation.

[piyushsarraf]

There is incorrect query generation while doing row validation for DB. When casting to string we are casting to CLOB and query is:

SELECT t6.guestname AS guestname, t6.content AS content, t6.entryid AS entryid, t6.guestname AS cast__guestname, t6.content AS cast__content, CAST(t6.entryid AS CLOB) AS cast__entryid 
FROM db2inst1.entries AS t6

But we are facing an error that:
A value with data type "SYSIBM.INTEGER" cannot be CAST to type "SYSIBM.CLOB".

I think instead of casting to CLOB casting to VARCHAR(n) will be a solution.

Some samples from DB2 terminal:

[ngdav]

What's the exact DVT command/config you're using when getting this error?