15.12 - Opening the Blob Editor - Teradata Studio

Teradata Studio Express User Guide

prodname
Teradata Studio
vrm_release
15.12
created_date
August 2016
category
User Guide
featnum
B035-2042-086K

You open the Blob Editor from the Table Data Editor by selecting the row that contains the Binary Large Object (BLOB) in the table.

A BLOB data object can be represented in one of three ways:
  • BLOB handle - Handle to the BLOB data in the database.
  • Snippet of data - Text snippet you edit or insert in cell.
  • Filename - For data objects over 64k, name of file that contains the data. You can edit or insert data in this file. BLOB data larger than 64k cannot be edited in the Blob Editor.

To open the Blob Editor:

  1. Select a table that contains a BLOB object and open it in the Table Data Editor. See Opening the Table Data Editor. The table name displays in the tab at the top of the editor. You can open several tables in the editor and move between them by clicking these tabs.
  2. Select the BLOB to edit from the Binary Large Objects column. Single objects are separated in rows.
  3. Click the ellipses () at the right end of the row to open the Blob Editor. See About the Blob Editor.