Import and export of table data containing BLOB fields in DB2

DB2 contains the Import and Export abstract of BLOB field table data: after the Toad tool is connected, execute the statement either in the control center or in the folder without other files. After the Toad tool is connected, execute the statement either in the control center or in the folder without other files.

Import from D: \ lnwq_blob_report \ records of del lobs from d: \ lnwq_blob_report \ modified by lobsinfile replace into UNIEAP_REPORT_DEFINE; export to E: \ test1 \ records of del lobs to e: \ test1 \ LOBFILE UNIEAP_REPORT_DEFINE modified by lobsinfile messages oyp. OUT select * from UNIEAP_REPORT_DEFINE

 

After the Toad tool is connected, execute the statement or execute it in the control center. do not include any other files in the folder.