Hi

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,
MY_BLOB BLOB(1M)
);

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

1,"file1.001"
2,"file2.001"

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.


Cheers

Bind db2ubind.lst. See:
Import error - UDB version DB2/NT 8.2.8