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.
- Click Query Development to open the Query Development perspective.
- Open the Data Source Explorer and navigate to the table in which you want to insert rows.
-
Right-click the table object and select one of these options:.
For Select Teradata Database Aster Database - In the SQL Editor, modify the generated INSERT statement to specify the values for the columns based on data types.
- Click to execute the INSERT statement to insert the row into the table.