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;
Is it possible for me to export/import BLOB data? How is this done?
Thanks in advance!