In DB2 , how do we write a query to fetch value from clob datatype column
A:
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.
Swoop
2010-08-24 12:10:34
A:
For sql/pl, you can select clob data from database same other type, but if you use jdbc I should byte[] for Clob data.
Fuangwith S.
2010-08-24 18:27:12
thanx for the suggestion. This is the first time i am using DB2.. is the. I need to test the query with a standalone class, is the driver for DB2 available as free.
P.E
2010-08-25 04:02:23