Displaying Column Data by Value - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.