Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    60

    Unanswered: Inserting File into BLOB Column

    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •