DB2 graphic QMF Version 8

View and edit LOB data

You can update the LOB on the server only if you are in edit mode.

Follow these steps to view or edit LOB data:

  1. Double-click on a cell labeled <LOB locator>.

    The Column LOB Type Associations dialog box opens. Use this dialog box to specify the Windows file format of the data.

  2. Click the Mapping button.

    The File Extension Mapping dialog box opens.

  3. Select the file extension for the LOB at the File Extension column.

    For example, if the mapping value is bitmap, change the file extension from LOB to .bmp.

    Note:
    Certain applications display specific file extensions. Refer to the manual for your application to determine which files are supported.
  4. Click OK

    The Column LOB Type Associations dialog box opens.

  5. Click OK.

    The Column LOB Type Associations dialog box closes and the LOB opens in the designated application.

  6. Click OK.

    A message box indicates how many rows in the database will be affected by the operation.

    The LOB locators column now contains icons that correspond to the application, such as for bitmaps.

  7. Select Results" Save to Database to save the query to the server.


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