Was this helpful?
APPEND--Add a Table Row
Adds a row to a database table.
This statement has the following format:
[##] [repeat] append [totablename  (columnname = expression 
              {,columnname = expression}) [where qual]
The append statement adds a row to the specified table. The columns of the row contain the values assigned in the columnname = expression clauses.
To reduce processing overhead for frequently repeated appends, specify the repeat option. Repeat directs the DBMS Server to save an execution plan after the append is first executed. In repeat append statements, you must flag variables if their values change (or can possibly change) each time the append is executed. If the variable appears on the right side of an equal sign (=), it must be preceded by an "at" sign (@). The @ flag tells the EQUEL preprocessor that the value of the variable must be checked each time the query is executed.
Last modified date: 11/28/2023