View Poll Results: export file with blob field show garbages

Voters
0. You may not vote on this poll
  • a

    0 0%
  • b

    0 0%
Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    7

    Unanswered: Export file and Blob field shows Garbages

    Hi there,

    I'm trying to perform the following:

    EXPORT TO d:\bkA OF DEL lobs to d:\bkA MESSAGES d:\bkA\bkA.log select * from fos.bkA

    However, in the the file bkA, there is this blob column which shows garbages.
    How should I go about extract the data for this blob column accurately?
    Please advise. Thank you very much.

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Joshua,

    Look into Command Ref.

    It looks like you might be missing at least 2 parms lobfile and modified by lobsinfile
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Dec 2005
    Posts
    7
    Hi Courgar8000,

    If i don't use lobfile :

    EXPORT TO d:\bkA OF DEL MESSAGES d:\bkA\bkA.log select * from fos.bkA

    Inside table bkA before download is a blob which contained valid data.
    But when exported, it contained garbages.
    How should I export it correctly?
    Please advise. Thank you.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Use db2look. That way it will figure out who to export for you since you don't know how to do it yourself.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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