Insert Rows into the Database from the Interactive SQL Result Set

Interactive SQL allows you to add new rows to a table. You tab between columns in the result set to add values to the row. You must have INSERT permission on the table to add new rows.

• Inserting a New Row into the Result Set
  Add a new blank row to the table from the result set.
• Inserting Values into Columns with Default Values
  When adding a value in a column that has a default value, the cell editor contains a list with a (DEFAULT) item. Similarly, if a column accepts NULL values, (NULL) appears in the list.
• When the Result Set Contains a Computed Column
  If the result set contains a computed column and you do not specify a value for the computed column, the value is calculated when the database is updated. However, if you specify a value for the computed column, the database is updated with the specified value, and a value is not calculated for the computed column.
• Inserting New Rows Using the INPUT Statement
  An alternative to inserting new rows from the result set in Interactive SQL is to add rows using the INPUT statement with the PROMPT clause.