[DB2EUG] CLOB usage in DB2 for OS/390 V7, text extenders?

Thu, 29 Jan 2004 10:03:44 -0800

Hi to all,
We are using DB2 for OS/390 V7. Our Java application developers want to use CLOBS in their tables. That is, they want to store  100 KB long HTML files in OS/390 DB2 tables. They want to display this HTML CLOB data on Java .jsp pages.
 
We have followed the redbook Large Objects with DB2 for zOS and OS390.
 
We have run the samples in Appendix A and Appendix D.
That is, we have loaded an 500 KB HTML file to a CLOB column.
 
I wonder how can our Java programmers display this data? When we write a SELECT statement on this table, we get SQLCODE -776.
 
We don't have any experience in using extenders. Do we have to install-use text extenders on OS/390 to SELECT and display CLOB objects?
 
Anyt comments?
 
Regards,
 
kadir guray meric
 

Reply via email to