Retrieving Table Rows using a SELECT Template - 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
  1. Click Query Development to open the Query Development perspective.
  2. Open the Data Source Explorer and navigate to the Teradata or Aster database table in which you want to insert rows.
  3. Right-click the table object and select one of these options:
    For Select
    Teradata Database Teradata > Generate SQL > SELECT Statement
    Aster Database Aster > Generate SQL > SELECT Statement
    Hadoop File System Hadoop > SELECT Statement
  4. In the SQL Editor, review the generated SELECT statement and edit as needed.
  5. Click to execute the SELECT statement to retrieve the row in the table.