16.00 - Displaying Column Data by Value - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

You can specify to show values by columns.

  1. Right-click in the column header of the column in which you want to show specific values.
  2. Select Show Values.
  3. In the Show Values dialog, select from one of the two steps below as the options are different based on the data type of values in the selected column.
  4. To show values for DECIMAL, FLOAT, INTEGER, SMALLINT, BYTEINT, BIGINT, TIME, TIMESTAMP, or DATE data types, select from these options:
    Option Description
    Show Values Equal with Type a numeric value to match against column data values that are equal to the value you enter.
    Show Values Greater than Type a numeric value to match against column data values that are greater than the value you enter.
    Show Values Less than Type a numeric value to match against column data values that are less than the value you enter.
  5. To show values for the VARCHAR data type, select from these options:
    Option Description
    Show Values that Start with Type a value to match against the initial characters of a data value in the selected column. The field supports alpha-numeric characters. Do not use special characters or wildcards.
    Show Values that End with Type a value to match against the end characters of a data value in the selected column. The field supports alpha-numeric characters. Do not use special characters or wildcards.
    Show Value that Contains Type the value you want to match against characters contained in data values in the selected column. The field supports alpha-numeric characters. Do not use special characters or wildcards.
  6. Click OK.