Is it possible to see BLOB content in CLP?

jinsezh · #1 (**permalink**) 12-19-06, 14:11

Hi there,

I have a blob which only contains XML strings, so I wonder is there any way I can see the BLOB content( First 200 chars is enough) in CLP.

Mine is DB2 v8.2

Thanks,
Jinse

guyprzytula · #2 (**permalink**) 12-20-06, 01:24

so why was blob and not clob used - if keeping regular readable data
blob is for objects -(gif,pdf...)
clob can be displayed just by select * from table

jinsezh · #3 (**permalink**) 12-20-06, 14:25

Quote:

Originally Posted by guyprzytula

so why was blob and not clob used - if keeping regular readable data
blob is for objects -(gif,pdf...)
clob can be displayed just by select * from table

Unfortunately, I am not the one who decide data types, and have to live with BLOB.

So there is no way to see BLOB in select query?

Coolhard · #4 (**permalink**) 12-21-06, 01:21

Hi guyprzytula,

May I know how to store the CLOB data type in DB2 UDB v7.1 onward?
Can I use insert into statement as usual?

Thanks,

Quote:

Originally Posted by guyprzytula

so why was blob and not clob used - if keeping regular readable data
blob is for objects -(gif,pdf...)
clob can be displayed just by select * from table

guyprzytula · #5 (**permalink**) 12-21-06, 01:45

see recent entries
How to store the images in db2 as BLOB ?????

Internet Services

Web Development

Digital Marketing

Consumer Tech