var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Inserting File into BLOB Column
I want to insert XML, TXT files into a blob column in one of my table.
I tried the following.
CREATE TABLE BLOB_TEST(
ID INTEGER NOT NULL,
I have couple of files in \\svr09\xml folder ( file1.001 and file2.001)
I have another file test.txt which contains the following data
Now when i try to import from Toad for DB2 Freeware using the following command.
import from test.txt of DEL LOBS from '\\svr09\XML\' modified by lobsinfile insert into blob_test
The first time i ran this above command i got the following error.
Error 17-10-2011 12:11:45 0:00:00.000 SQL0719N Bind error for user "XXXX". Package "NULLID.SQLUAH18" already exists. SQLSTATE=42710 9 0
When i run the same command again. I got the following error.
Error 17-10-2011 12:12:54 0:00:00.000 SQL3015N An SQL error "-805" occurred during processing.
SQL0805N Package "NULLID.SQLUFH13 0X4141414141594758" was not found.
SQLSTATE=51002 9 0
Any help to resolve the above issue is highly appreciated.
I am using DB2 9.5 LUW on windows.