DB2 graphic QMF Version 8

Retrieving LOBs from a database

Procedure

  1. Run the query or procedure that calls the table where the LOB is stored on the database.

    The table with the LOB data is retrieved from the server.

    Note:
    Each cell in the column containing LOB data is identified with the label, <LOB locator>.

    If status bar at the bottom of the window displays the message, All rows retrieved, more LOB data to retrieve, it means that transferring LOB data can be resource-intensive. By default, QMF for Windows returns LOB locators that refer back to the actual data on the database. The LOB data will be retrieved on demand or when a function requires it.

  2. Optional: Select View--> Options.

    The Options dialog box displays.

    1. Click LOBs to change the default options for retrieving LOBs.
    2. Check the Override LOB options, if possible check box to make changes to the LOB options.
      Note:
      This option is available only if your database administrator has granted override authority to you.


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