Hello, I am trying out LOBs in DB2 and trying to insert into a table which has a single column defined as CLOB. I am running DB2 V7.1 PE (fixpak 2a) on NT. Table: MYTEST Column name: MYDOC - defined as - CLOB - size - 100MB - nullable How do I insert a document, say a text document, which is on my local drive, say: c:\sinha\testdoc.txt into the above column, either from a Command Line processor (INSERT INTO ...stmt) or using the Command Center (using SQL Assist) ? Do I need a LOB locator, and if so, where and how can I define a locator etc. ? I have never worked with LOBs before. What I finally intend to do is use a CLOB column in a Java stored procedure and access it from a Java application. Right now, a Java stored proc does not accept LOB parameters, but the following Client Build Release is supposed to fix it: ftp://ftp.software.ibm.com/ps/products/db2/fixes/english-us/client_build/ Check out APAR: IY17516 SQL0311 WHEN CALLING SP FROM JAVA WITH CLOB PARAMETER Any help will be much appreciated. Regards, Abhijit Sinha ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
