Results 1 to 2 of 2

Thread: Unload utility

  1. #1
    Join Date
    Aug 2007
    Posts
    56

    Unanswered: Unload utility

    DB2 V8 Z/os

    I am trying to unload a table that has a blob(100K) and receive a size error.

    Is there a limit on the size of the lob field?

    Any help would be appreciated.

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    Did you try using TRUNCATE key word in unload statements. Try one of the following options.

    1. UNLOAD DATA FROM TABLE
    BLOBCOLUMN TRUNCATE
    or

    2. UNLOAD DATA FROM TABLE
    BLOBCOLUMN VARCHAR BLOBF TSYSLOB

    TSYSLOB is template. You need to define for DSN.

Posting Permissions

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