DB2 graphic QMF Version 8

Exporting LOB data

Purpose

Use this option to export LOB data retrieved from the database.

Map the file extensions before you export LOB data retrieved from the database (see View and edit LOB data), then the export is similar to exporting ordinary data, but with LOB option specifications.

For example, you can export a LOB as a bitmap, then save it as an HTML file (.htm) in the Export Data dialog box.

For most LOB data, an HTML form may make the most sense because the file can be displayed as an HTML address for HTML reports and web pages. For more sophisticated web pages, use the HTML Form capabilities in QMF for Windows.

Procedure

Follow these steps to export LOB data into an .ixf, .txt or .html file:

  1. Select Results--> Save to File.

    The Export Data dialog box opens.

  2. Type a file name.
  3. Select a file type, such as .ixf, .txt or .htm, in the Save as Type list box.
  4. Click Options.

    The Export Text/DEL Options (General tab) dialog box opens.

  5. Click the LOBs tab.

    The Export Text/Del Options (LOB tab) dialog box opens.

  6. Choose a directory and a naming convention for your LOB data (database name).
  7. Click OK.

    The Export Data dialog box opens.

  8. Click Save to save the file to the specified directory.

    When opened, the text file displays the LOB query results information that was exported from the query results. The HTML file displays an active link.

  9. Click the LOB link to display the LOB data in the selected application.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004