Clob Editor | Teradata Studio/Studio Express - Clob Editor - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the Table Data Editor to review and edit database tables that contain Character Large Objects (CLOBs). A CLOB is a collection of character data stored as a single entity in a Database Management System (DBMS).

The Clob Editor displays the character data contained in the selected Character Large Object (CLOB) stored in a database. You can edit the data in the CLOB by:
  • Inserting character data
  • Deleting character data
  • Clearing the character data in the object
  • Importing character data from a file
  • Exporting the character data in the object
A CLOB data object can be represented in one of three ways:
  • CLOB handle – Handle to the CLOB 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. CLOB data larger than 64K cannot be edited in the Clob Editor.