Editing Large Text Data - Teradata Studio

Teradata Studio Express User Guide

Product
Teradata Studio
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
mco1486739961504.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities

You can use the Table Data Editor to display and edit tables that contain character data. A large text data table contains large amounts of character data stored as VARCHAR data type. The Table Data Editor provides a special Large Text Editor for this type of data.

  1. Select a table that contains large rows of character data (VARCHAR) in your database. Data is stored as single objects in separate rows.
  2. Right-click the table and select Teradata > Edit Data. You can open several tables in the editor in this way and move between them by clicking the tabs at the top of the editor.
  3. The large text data displays in the VARCHAR column in the Table Data Editor.
  4. Locate the row you want to edit and select it. The table row highlights, and an ellipses () displays at the right end of the row.
  5. Click the ellipses () to open the Large Text Editor.
  6. Review and edit the data displayed in the editor. You can edit directly in the editor or you can export the VARCHAR or CHAR data to a Microsoft Word or text file to review and edit the data, and then import that data back to the Large Text Editor.
  7. Click OK to save your changes to the object.