INSERT
The INSERT statement inserts rows into a table or
view. Inserting a row into a view also inserts the row into the table on which
the view is based if no INSTEAD OF INSERT trigger is defined on this view.
If such a trigger is defined, the trigger will be executed instead.
There are three forms of this statement:
- The INSERT using VALUES form is used to insert
one or more rows into the table or view using the values provided or referenced.
- The INSERT using SELECT form is used to insert
one or more rows into the table or view using values from other tables or
views.
- The INSERT using n ROWS form is used to insert
multiple rows into the table or view using the values provided in a host-structure-array.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.