Convert BLOB to CLOB

grofaty · #1 (**permalink**) 12-04-08, 06:52

Hi,
on db2 v9 zOS I would like to convert BLOB data to CLOB data. I see this is some kind possible using UDF, but is there any more simple way of doing it?
Regards,
Grofaty

n_i · #2 (**permalink**) 12-04-08, 08:15

I think the UDF method is the only way, at least for now. In DB2 9.5 you could CAST between BLOB and CLOB types.

grofaty · #3 (**permalink**) 12-04-08, 08:16

Hi,
can you please provide any sample for v9.5 for cast?
Regards,
Grofaty

stolze · #4 (**permalink**) 12-04-08, 08:55

Good question. I can cast from CLOB to BLOB (nothing new there), but a cast from BLOB to CLOB doesn't work on V9.5.

Internet Services

Web Development

Digital Marketing

Consumer Tech