Table Data Editor Preferences - 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
Set preferences to determine how the Table Data Editor displays. You can set these features:
  • Show or hide numbered row column header
  • Background color for alternate table rows
  • Highlighted row color for inserted, updated, and deleted data
  • Thresholds for filter and transaction rows

Color Options

To control color, choose from these options:

Option Description
Display alternate Result Set rows in color Select the check box to enable an alternate row background color, and then select the color. Click the color box to see color options.
Insert Selection Color Click the color box to select the background color for inserted data.
Update Selection Color Click the color box to select the background color for updated data.
Delete Selection Color Click the color box to select the background color for deleted data.

Editor Options

To set edit preferences, choose from these options:

Option Description
Show Row Numbers Select the check box to show numbered rows in the first column of the data grid.
Display Filter Dialog Threshold (rows) Enter the number of table rows above which the Table Data Editor presents the Data Filter dialog. Be sure to specify filters in the Table Data Editor to reduce the number of data rows that display. The default is 500000.
Transaction Commit Size (rows) Enter the number of data rows to batch in a single COMMIT transaction. This number is the threshold at which the batch UPDATE operation occurs. For example, if you set the threshold at 1000, the operation batches 1000 data row updates in a single COMMIT transaction. The default is 500.

Copy and Paste Options

To set copy and paste preferences, choose from these options:

Option Description
Copy Column Names when Copying Rows Select the check box to include column header labels when copying data to a file.
Column Delimiter Select from the list the type of delimiter to use to separate data when copying or pasting from the editor to a file, such as Microsoft EXCEL or Notepad. Supported delimiters are: Tab (default), Comma, Semicolon, and Space.

Actions

Apply, restore, or save your settings by choosing from these options:

Option Description
Apply Click to apply your changes. You can preview results in the Table Data Editor.
Restore Defaults Click to return to default values.
OK Click to save your preference settings.