Inserting Table Rows using an INSERT Template - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
You can generate an INSERT statement template in the SQL Editor that inserts rows in a Teradata or Aster database table. The INSERT (Values) Statement menu option enables you to modify the generated statement and provide all query values. If you want to create a parameterized query, select the INSERT (Parameterized) Statement menu option.
  1. Click Query Development to open the Query Development perspective.
  2. Open the Data Source Explorer and navigate to the 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 > INSERT (Values) Statement
    Aster Database Aster > Generate SQL > INSERT (Values) Statement
  4. In the SQL Editor, modify the generated INSERT statement to specify the values for the columns based on data types.
  5. Click to execute the INSERT statement to insert the row into the table.