If a table or view in your IBM database is defined with one or more columns of data type BLOB, you can use the IBM^® Data Designer to review the BLOB data that is stored in rows of the table or view. You can also use the IBM Data Designer to review BLOB data that results from running an SQL procedure or function.

Requirements:

• The table or view must be defined with one or more columns of data type BLOB.
• The data that results from running an SQL procedure or function must contain at least one column of BLOB data.

To review the BLOB data:

1. Retrieve the data from a table or view, or run an SQL procedure or function.
2. To see the BLOB document that is in a cell of the result data grid in the designer:
   1. Click the cell in the result data grid, and then click .

      The BLOB Visualizer window opens.

   2. Select the MIME type of the BLOB document, and then click View.

      The BLOB document is displayed in the Value field.

   3. Close the BLOB Visualizer window.

After you have reviewed the BLOB data in a column of a table or view, you can import BLOB data to a cell in the result data grid, and update or delete the BLOB data that is displayed in a cell.

See Also

Importing BLOB Data to Tables and Views | Changing BLOB Data in Tables and Views | Deleting BLOB Data from Tables and Views

.NET Development Forum   DB2 FAQs   IDS FAQs

© Copyright IBM Corporation 2002, 2019. All Rights Reserved.