Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Location
    Philippines
    Posts
    11

    Question Exporting Tables with BLOBs

    Hi,

    When transferring data between DBs, I usually use Control Center Import/Export functions (comma delimited). However, I tried doing this with a table with a BLOB field (usually a pdf file), and it didn't work(wrong data even for non-BLOB fields). I tried changing the export format to IXF, it worked a little better as the non-BLOB fields had correct data. The BLOB field however could no longer be viewed correctly as pdf. The script below was taken from the "Show Command" option.

    CONNECT TO TestDB USER dbadmin USING *****;
    EXPORT TO C:\doc.ixf OF IXF MESSAGES msg SELECT * FROM DBADMIN.DOCUMENT;
    CONNECT RESET;

    Is it possible for me to export/import BLOB data? How is this done?

    Thanks in advance!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,460
    Code:
    EXPORT TO C:\doc.ixf OF IXF 
    LOBS TO C:\lobs MODIFIED BY lobsinfile
    MESSAGES msg SELECT * FROM DBADMIN.DOCUMENT;

Posting Permissions

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