Inserting Table Rows using Parameterized Queries - Teradata Studio

Teradata Studio Express User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cxo1484765174902.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities
You can generate an INSERT statement template in the SQL Editor that uses parameter placeholders in those cases where you could specify constants. When you execute the SQL, the editor prompts you to specify the values for each of the parameter placeholders. You also have the option to load the default values for the parameters.
  1. Click Query Development to open the Query Development perspective.
  2. Open the Data Source Explorer and navigate to the 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 > INSERT (Parameterized) Statement
    Aster Database Aster > Generate SQL > INSERT (Parameterized) Statement
  4. In the SQL Editor, review the generated INSERT statement and edit as needed.
  5. Click to execute the INSERT statement.
  6. In Configure Parameters, specify the values for each of the parameters or click Load Defaults to specify default values.
  7. Click OK. The SQL INSERT statement runs and inserts the row in the table.