DB2 query for fetching clob value

In DB2 , how do we write a query to fetch value f开发者_如何学运维rom clob datatype column

Not sure if this will help with your situation, but we ran into a similar situation at my company. For us, we were able to read the values out as a normal string using C#/.NET and the IBM iSeries data provider. The data we wanted to fetch from the CLOB was just simple text, which allowed this process to work.

For sql/pl, you can select clob data from database same other type, but if you use jdbc I should byte[] for Clob data.