Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    9

    Unanswered: export clob data to single file

    Hi,
    we are using DB2 v9.1.6, we need to export data from table having clob column to single file

    here is the tables:
    CREATE TABLE ABC.TEST (
    TEST_ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20) NOT NULL,
    NAME INTEGER,
    VALUE CLOB(500000))

    export cmd:
    db2 export to TEST.del of del modified by lobsinfile messages Test.msg SELECT * FROM ABC.TEST;

    Problem is since the CLOB value exceeds 32K we need to store CLOB data in different file but we don't want this to happen.

    Is there any way we can export CLOB data to single file ?

    Any suggestion is appreciated.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You can only export up to 32KB of LOB data inline

Posting Permissions

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