Editing CLOB Data - Teradata Studio

Teradata® Studio™ Express User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
mub1542649412178.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Select a CLOB table in your database.
  2. Right-click the table and select Data > Edit Data.
  3. Locate the CLOB you want to edit and select it.
  4. Click the ellipses () to open the Clob Editor.
  5. Review and edit the data in the object.
    CLOB data larger than 64k can be viewed, exported, and imported, but not edited in the Clob Editor. To edit files larger than 64k, export to a text editor.

    If the data in the object is imported, the source file for that data displays in the File field.

    The editor workarea displays the current data in the selected object for edit. You can insert, delete, and modify data displayed in this area. You can import from or export to files, such as a Microsoft Word file or text file. You can also remove all data by clicking Clear.

    You can export the data to a Microsoft Word or text file to review and edit the data, and then import that data back to the Clob Editor.

    The Encoding fields shows the encoding standard used for the data in the editor workarea. Use the drop-down menu to select a different standard.

  6. Click OK to save your changes to the object.